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

[kurt . lidl]

The following bug has been logged on the website:

Bug reference:  7836
Logged by:  Kurt Lidl
Email address:  kurt.l...@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=# 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=# copy pg_aggregate to '/tmp/agg.bin' with binary;
COPY 120




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

[Kurt Lidl]

On 1/29/2013 3:19 PM, hubert depesz lubaczewski wrote:

On Tue, Jan 29, 2013 at 06:20:05PM +, kurt.l...@cello.com wrote:

template1=# copy pg_aggregate to '/tmp/agg.bin' with format binary;


correct syntax:

copy pg_aggregate to '/tmp/agg.bin' with (format 'binary');

Best regards,

depesz



Oops.  Silly me.

Thanks for pointing out my missing parens.

-Kurt



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs