#PostgreSQL Help - Charsets
I have a little PostgreSQL database running for tinkering with at home. I am importing a text file from CLI using \copy. The text file is UTF8. The database is en_US.UTF8. Yet the import changes Mötley Crüe into Mötley Crüe, Motörhead into Motörhead. I've been staring at this too long now. Help!
Follow
#PostgreSQL Help - Charsets
@anomis66 documentation at https://www.postgresql.org/docs/current/sql-copy.html but probably you want to specify encoding 'utf8':
\copy (select * from systems) to stdout with (format 'csv', encoding 'utf8');
(Or you could try pg_dump instead.)
#PostgreSQL Help - Charsets
@h2g2bob Good shout! I would never have thought to force the encoding on the \copy even when the database collation and csv file are both already in UTF8 charset.
@mikedimmick