Maintaining accents with "COPY" ?

From: Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>
To: postgre <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Maintaining accents with "COPY" ?
Date: 2023-05-25 07:14:40
Message-ID: oecekDAbp5O7kdlV4eD_J2uPWFHDwuf4CO3DFaJHQiT7gbFp1peO0UYyAfkUDEvS1h8bjxrUMf91YPrjUr7Rib-flXJWwHyr2vRIt_S8hcI=@protonmail.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2023-05-25 07:48:26 Re: Maintaining accents with "COPY" ?
Previous Message Randy Needham 2023-05-24 21:02:04 Having issue with SSL.