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 >> If field1=2 make table2 and insert the

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

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

2009-05-25 Thread Grzegorz Jaśkiewicz
2009/5/25 Stephen Frost : > > Right, that would be option #3 from my list. :) Aye, The reason I am asking about version, is because 8.1 can't import CSV using COPY. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.pos

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

2009-05-25 Thread Stephen Frost
* Grzegorz Jaśkiewicz (gryz...@gmail.com) wrote: > On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote: > > > This currently can't be done with the COPY command directly.  There are > I would put it in postgresql as is, and than do "CREATE TABLE foo AS > SELECT CASE ... END ;" Right, that

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

2009-05-25 Thread Grzegorz Jaśkiewicz
On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote: > This currently can't be done with the COPY command directly.  There are I would put it in postgresql as is, and than do "CREATE TABLE foo AS SELECT CASE ... END ;" -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgr

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

2009-05-25 Thread Stephen Frost
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 > If field1=2 make table2 and insert the rest of field1=2 into this table > > Hence in this example one will have table1, ta

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

2009-05-25 Thread Grzegorz Jaśkiewicz
what's the postgrtesql version there ? (just do "select version();", or psql --version); -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general