Postgres Pro
Downloads
Home   >   mailing lists

Maintaining accents with "COPY" ? - Mailing list pgsql-general

From Laura Smith
Subject Maintaining accents with "COPY" ?
Date
Msg-id oecekDAbp5O7kdlV4eD_J2uPWFHDwuf4CO3DFaJHQiT7gbFp1peO0UYyAfkUDEvS1h8bjxrUMf91YPrjUr7Rib-flXJWwHyr2vRIt_S8hcI=@protonmail.ch
Whole thread Raw
Responses Re: Maintaining accents with "COPY" ?  (Erik Wienhold <ewie@ewie.name>)
Re: Maintaining accents with "COPY" ?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Randy Needham
Date:
Subject: Having issue with SSL.
Next
From: Erik Wienhold
Date:
Subject: Re: Maintaining accents with "COPY" ?