Re: [GENERAL] Assistance in importing a csv file into Postgresql

2009-05-25 Thread Intengu Technologies
Thanks for the pointers will try them. On 25/05/2009, Stephen Frost wrote: > Greetings, > > * Intengu Technologies (sindile.bi...@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 >> I

Re: [GENERAL] Assistance in importing a csv file into Postgresql

2009-05-25 Thread Intengu Technologies
Version 8.3.7 On 25/05/2009, Grzegorz Jaƛkiewicz wrote: > what's the postgrtesql version there ? > (just do "select version();", or psql --version); > -- Sindile Bidla -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postg

[GENERAL] Assistance in importing a csv file into Postgresql

2009-05-25 Thread Intengu Technologies
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","1" "2","2","RD","1" "4","2","RD","1" "4","2","RD","1" "5","2","RD","1" "5","2","RD","1" "5","2","RD","