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?
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? |