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(at)sraoss(dot)co(dot)jp wrote:

> 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
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

---------------------------------------
TAKATSUKA Haruka / harukat(at)sraoss(dot)co(dot)jp