Dear List I have a csv file that I would like to import into Postgresql, the structure of the csv file is in this format: "field1","field2","field3","field4" "1","2","RD","00001" "2","2","RD","00001" "4","2","RD","00001" "4","2","RD","00001" "5","2","RD","00001" "5","2","RD","00001" "5","2","RD","00001" "6","2","RD","00001" "1","3","RD","00003" "2","3","RD","00003" "3","3","RD","00003" "4","3","RD","00003" "4","3","RD","00003" "5","3","RD","00003" "5","3","RD","00003"
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. Postgresql is running on a Windows platform. Thanks in advance. -- Sindile Bidla -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
