You can specify the column order in the copy statement:
psql -d test -c "create table ttt (id serial primary key, name varchar(10), value int);"
echo "10|one" | psql -d test -c "copy ttt (value,name) from stdin with delimiter '|';"
psql -d test -c "select * from ttt;"
id | name | value
----+------+-------
1 | one | 10
(1 row)
HTH
Brent Wood
GIS/DBA consultant
NIWA
+64 (4) 4 386-0300
________________________________________
From: pgsql-general-owner@postgresql.org [pgsql-general-owner@postgresql.org] on behalf of MD33 [mdubosforum@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 necessary in my file ??
thxs
--
View this message in context: http://postgresql.1045698.n5.nabble.com/COPY-column-order-tp5690950.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.