Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected
Date
Msg-id 4DC884A9.9030008@timbira.com
Whole thread Raw
In response to BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected  ("pedro mg" <pedro@tquadrado.com>)
List pgsql-bugs
Tree view 
Em 09-05-2011 15:07, pedro mg escreveu:
> # COPY test1 FROM '/tmp/test1.csv' WITH CSV HEADER
>
Why don't you specify the columns?

COPY test1 (key, c2, c1) FROM '/tmp/test1.csv' WITH CSV HEADER


--
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-bugs by date:

Previous
From: "pedro mg"
Date:
Subject: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #6016: Documentation makes inappropriate reference to boolean logic