BUG #7518: "FORMAT" in the "COPY" command

From: matsusaka(at)sraoss(dot)co(dot)jp
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7518: "FORMAT" in the "COPY" command
Date: 2012-09-04 09:02:12
Message-ID: E1T8p1Q-00009N-5V@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7518
Logged by: Daichi Matsusaka
Email address: matsusaka(at)sraoss(dot)co(dot)jp
PostgreSQL version: 9.1.5
Operating system: (Centos5)
Description:

Hi,

I think manual "COPY" command to be in the wrong.

postgres=# COPY table_name TO '/tmp/out.csv' CSV;
COPY 1

postgres=# COPY table_name TO '/tmp/out.csv' FORMAT 'CSV';
ERROR: syntax error at or near "FORMAT"
LINE 1: COPY table_name TO '/tmp/out.csv' FORMAT CSV;

But, help is...

 postgres=# \h COPY
:
:
COPY { table_name [ ( column [, ...] ) ] | ( query ) }
TO { 'filename' | STDOUT }
[ [ WITH ] ( option [, ...] ) ]

where option can be one of:

FORMAT format_name -- Is here.
OIDS [ boolean ]
DELIMITER 'delimiter_character'
:

Is the same manual.
http://www.postgresql.org/docs/9.2/static/sql-copy.html

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message TAKATSUKA Haruka 2012-09-04 09:13:24 Re: BUG #7518: "FORMAT" in the "COPY" command
Previous Message fx HABAGUCHI KATSUHITO 2012-09-04 08:17:22 Re: BUG #7517: terminated by exception 0xC0000409