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

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

Hi,

It's not bug.

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

This should be the following.

  COPY table_name TO '/tmp/out.csv' (FORMAT 'CSV')


On Tue, 04 Sep 2012 09:02:12 +0000
matsusaka@sraoss.co.jp wrote:

> 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=# 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...
>
> $B!!(Bpostgres=# \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
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

---------------------------------------
TAKATSUKA Haruka / harukat@sraoss.co.jp