Greetings,
* Intengu Technologies (sindile.bidla@gmail.com) 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