Hi.
use set client_encoding=''SJIS be the same to export PGCLIENTENCODING=SJIS.
But can not export the data to csv file corecttly without errror,
just because the character which is not SJIS encoding.
Um, Please show the information on your database of 7.3.
ex)
postgres=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(3 rows)
Probably, your database is SQL_ASCII ?
Regards,
Hiroshi Saito
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match