Hi
I'm currently doing a CSV export using COPY:
COPY (select * from foo where bar='foo') TO '/tmp/bar.csv' DELIMITER ',' CSV HEADER;
This works great apart from accents are not preserved in the output, for example é gets converted to random characters, e.g. √© or similar.
How can I preserve accents ?
Thanks !
Laura