Maintaining accents with "COPY" ?

[Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx>]

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