Re: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: pedro mg <pedro(at)tquadrado(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected
Date: 2011-05-10 00:19:53
Message-ID: 4DC884A9.9030008@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2011-05-10 01:04:37 Re: BUG #6016: Documentation makes inappropriate reference to boolean logic
Previous Message pedro mg 2011-05-09 18:07:25 BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected