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