"Chris Curvey" <chris@chriscurvey.com> writes:
> 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".
Quite.
> 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';
That is the old-style syntax, which doesn't allow newer options such as
FORMAT. Use
copy zipcode_stage from '/path/to/zip_codes.csv' (format csv, header, delimiter e'\t');
If you can make any concrete suggestions about how to make the docs
clearer about this, please do.
regards, tom lane