Help - moving data to new table structure

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Help - moving data to new table structure
Date: 2003-01-09 14:15:43
Message-ID: 20030109.3Ut.09509300@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm working on moving contact data from MS Access to some predefined tables in
PostgreSQL (part of another application)

I need some help creating one of the append queries

The Access tables include a table called "Contact Type" that is linked
to "Contacts" (the main table for the contact data) with a one to many type
relationship (ie each contact can have many types attached to it)

The new table layout in PostgreSQL will allow multiple contact types, but they are
listed as comma separated values in one field. The php code in this app then
matches up the comma separated values with corresponding records in the "Contact
Type" table

How the heck do I make a query to transfer the data to this new format?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-09 14:26:22 Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
Previous Message Chris Boget 2003-01-09 14:13:35 Re: How can I do this?