How to use postgresql copy command with ANSI encoding?

Question

I use PostgreSQL copy command to make a csv file.

COPY (select * from table) from '/tmp/123456.csv' with csv header encoding 'UTF8';

this command is ok

But I want to make file with ANSI encoding, because I want to open it in Microsoft Excel

COPY (select * from table) from '/tmp/123456.csv' with csv header encoding 'ANSI';

this command can't make csv file

There is no encoding "ANSI". If you mean a single-byte encoding, then you probably want ISO-8859-1 — user330315
– user330315, Commented Nov 7, 2016 at 10:14

Laurenz Albe · Accepted Answer · 2016-11-07 10:20:01Z

3

Since you seem to be on Windows, maybe you want to use one of the Windows encodings, for example WIN1252 for western European languages.

answered Nov 7, 2016 at 10:20

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1