From: | matsusaka(at)sraoss(dot)co(dot)jp |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7518: "FORMAT" in the "COPY" command |
Date: | 2012-09-04 09:02:12 |
Message-ID: | E1T8p1Q-00009N-5V@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | TAKATSUKA Haruka | 2012-09-04 09:13:24 | Re: BUG #7518: "FORMAT" in the "COPY" command |
Previous Message | fx HABAGUCHI KATSUHITO | 2012-09-04 08:17:22 | Re: BUG #7517: terminated by exception 0xC0000409 |