The following bug has been logged online: Bug reference: 5964 Logged by: Chris Curvey Email address: ch...@chriscurvey.com PostgreSQL version: 9.0.3 Operating system: Linux (ubuntu 10.10 server 64-bit) Description: doc bug -- copy does not take "format" literal Details:
in http://www.postgresql.org/docs/9.0/static/sql-copy.html, the documentation implies that you specify a format using the literal "format", followed by one of the literals "text", "csv" or "binary". Yet the following statement fails with "syntax error near 'format'" copy zipcode_stage from '/path/to/zip_codes.csv' format csv header delimiter e'\t'; and the following command (without 'format' succeeds) copy zipcode_stage from '/Users/chris/pgperf/data/zip_codes.csv' csv header delimiter e'\t'; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
