From: | Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Assistance in importing a csv file into Postgresql |
Date: | 2009-05-25 15:07:56 |
Message-ID: | a1afa64b0905250807j1f99f17cx71ea06a1b4ff0ba@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Jaśkiewicz | 2009-05-25 15:10:45 | Re: Assistance in importing a csv file into Postgresql |
Previous Message | Bayless Kirtley | 2009-05-25 14:43:07 | Re: Daylight saving time question |