Re: [GENERAL] COPY column order

2012-05-08 Thread MD33
HEADER option is not as useful as I wanted, but sounds good with column names. Thanks a lot ! -- View this message in context: http://postgresql.1045698.n5.nabble.com/COPY-column-order-tp5690950p5696058.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsq

Re: [GENERAL] COPY column order

2012-05-07 Thread Brent Wood
..@yahoo.com] Sent: Tuesday, May 08, 2012 12:33 AM To: pgsql-general@postgresql.org Subject: [GENERAL] COPY column order Hi there I'm trying to use COPY with HEADER option but my header line in file is in different order than the column order specified in database. Is the column name order

Re: [GENERAL] COPY column order

2012-05-07 Thread Adrian Klaver
On 05/07/2012 05:33 AM, MD33 wrote: Hi there I'm trying to use COPY with HEADER option but my header line in file is in different order than the column order specified in database. Is the column name order necessary in my file ?? From the docs: http://www.postgresql.org/docs/9.0/interactive/sq

[GENERAL] COPY column order

2012-05-07 Thread MD33
Hi there I'm trying to use COPY with HEADER option but my header line in file is in different order than the column order specified in database. Is the column name order necessary in my file ?? thxs -- View this message in context: http://postgresql.1045698.n5.nabble.com/COPY-column-order-tp56