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