Is it possible to turn off quote processing in the Postgres COPY command with CSV format?

Workaround (thanks to this comment!)

COPY <tablename> FROM <filename> WITH CSV DELIMITER E'\t' QUOTE E'\b' NULL AS '';

So basically specifying a quote character that should never be in the text, but that’s pretty ugly.

I’d much prefer it if there was in fact a way to turn off quote processing altogether.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)