Hi guys,
Any idea what else can I check ? it seems client_encoding isnt set or is default when I query pg_file_settings.
2018-07-11 17:49 GMT+03:00 Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>:
postgres=# select * from pg_file_settings where name = 'client_encoding';sourcefile | sourceline | seqno | name | setting | applied | error------------+------------+-------+------+---------+--------- +------- nothing..
2018-07-11 17:46 GMT+03:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
... btw, another possible aid is
select * from pg_file_settings where name = 'client_encoding';
https://www.postgresql.org/docs/current/static/view-pg-file- settings.html
regards, tom lane