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