> Looks like an encoding issue and a mismatch between database encoding and client > encoding. You can check both with: > > SHOW server_encoding; > SHOW client_encoding; > > Then either set the client encoding or use COPY's encoding option to match the > database encoding (I assume utf8 in this example): > > SET client_encoding = 'utf8'; > COPY (...) TO /tmp/bar.csv DELIMITER ',' CSV HEADER ENCODING 'utf8'; > > -- > Erik Hi Erik, Looks like you could well be right about encoding: postgres=# SHOW server_encoding; server_encoding ----------------- UTF8 (1 row) postgres=# SHOW client_encoding; client_encoding ----------------- SQL_ASCII (1 row) I will try your suggestion...
