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

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