The following bug has been logged on the website:
Bug reference: 7518
Logged by: Daichi Matsusaka
Email address: matsus...@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...
　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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
