BUG #7518: "FORMAT" in the "COPY" command

Поиск
Список
Период
Сортировка
От matsusaka@sraoss.co.jp
Тема BUG #7518: "FORMAT" in the "COPY" command
Дата
Msg-id E1T8p1Q-00009N-5V@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7518: "FORMAT" in the "COPY" command  (TAKATSUKA Haruka <harukat@sra.co.jp>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #7517: terminated by exception 0xC0000409
Следующее
От: TAKATSUKA Haruka
Дата:
Сообщение: Re: BUG #7518: "FORMAT" in the "COPY" command