BUG #7836: COPY command does not honor 'FORMAT' option - Mailing list pgsql-bugs

From kurt.lidl@cello.com
Subject BUG #7836: COPY command does not honor 'FORMAT' option
Date
Msg-id E1U0Fmv-0004Nq-ML@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7836: COPY command does not honor 'FORMAT' option
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #7836: COPY command does not honor 'FORMAT' option