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.

Tags:

Postgresql