BUG #7518: "FORMAT" in the "COPY" command - Mailing list pgsql-bugs

From matsusaka@sraoss.co.jp
Subject BUG #7518: "FORMAT" in the "COPY" command
Date
Msg-id E1T8p1Q-00009N-5V@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7518: "FORMAT" in the "COPY" command  (TAKATSUKA Haruka <harukat@sra.co.jp>)
List pgsql-bugs
The following bug has been logged on the website:

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


Hi,

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

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

 postgres=3D# 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...

=E3=80=80postgres=3D# \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

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #7517: terminated by exception 0xC0000409
Next
From: TAKATSUKA Haruka
Date:
Subject: Re: BUG #7518: "FORMAT" in the "COPY" command