BUG #7836: COPY command does not honor 'FORMAT' option

Поиск
Список
Период
Сортировка
От kurt.lidl@cello.com
Тема BUG #7836: COPY command does not honor 'FORMAT' option
Дата
Msg-id E1U0Fmv-0004Nq-ML@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7836: COPY command does not honor 'FORMAT' option  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7836
Logged by:          Kurt Lidl
Email address:      kurt.lidl@cello.com
PostgreSQL version: 9.2.2
Operating system:   FreeBSD 9.1 (i386 - 32bit)
Description:        =


The COPY documentation says that with 9.1 (or newer), there is an option
called "FORMAT", so the user can do "FORMAT binary".  The old way just used
a keyword "binary", and this way is supported for backwards compatibility.

However, it doesn't appear that the "FORMAT" keyword works properly:

psql -U pgsql template1
psql (9.2.2)
Type "help" for help.
template1=3D# copy pg_aggregate to '/tmp/agg.bin' with format binary;
ERROR:  syntax error at or near "format"
LINE 1: copy pg_aggregate to '/tmp/agg.bin' with format binary;
                                                 ^
template1=3D# copy pg_aggregate to '/tmp/agg.bin' with binary;
COPY 120

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #7836: COPY command does not honor 'FORMAT' option