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