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
