Thanks Kris and Oliver for your explanations.
Why I want to set the client_encoding to latin1? That's a fair
question. Unfortunately I removed the statement following the COPY
command to keep the posting short:
SET CLIENT_ENCODING TO 'LATIN1';
COPY temp_test FROM '/home/postgres/temp_test.dat';
I want to load a latin1-encoded file using the COPY command. Not
setting the encoding leads to the following error message:
22021
ERROR: Unicode characters greater than or equal to 0x10000 are
not supported
Executing the same COPY statement with psql works fine.
Cheers,
Adrian