Thanks for the pointers will try them. On 25/05/2009, Stephen Frost <sfrost@xxxxxxxxxxx> wrote: > Greetings, > > * Intengu Technologies (sindile.bidla@xxxxxxxxx) wrote: >> What I would like to do is >> >> If field1=1 make table1 and insert the rest of field1=1 into this table >> If field1=2 make table2 and insert the rest of field1=2 into this table >> >> Hence in this example one will have table1, table2, table3, table4, >> table5 and table6 >> >> How can I accomplish this using the COPY command. > > This currently can't be done with the COPY command directly. There are > a couple of options: > > #1- Have a single table with a trigger on it that does this for you > #2- Write a simple perl script which does this for you > #3- Load the data into one table and then use SQL to move it to the > other tables (which you would need to create first) > > Enjoy, > > Stephen > -- Sindile Bidla -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
