syntax error at or near "(" COPY FROM WITH ( FORMAT csv, DELIMITER E'\t', QUOTE '*', HEADER false, ENCODING 'UTF8')
The syntax of COPY
has changed quite a bit in version 9.0 compared to 8.4
Assuming you're using version 8.4, based on this .../PostgreSQL/8.4/...
path,
the syntax that applies is documented here:
http://www.postgresql.org/docs/8.4/static/sql-copy.html
And it does not allow any parenthesis after the WITH
keyword that appeared in 9.0, nor the ENCODING
option that appeared in 9.1
It looks like you need to adapt the statement to your exact version of PostgreSQL.