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