Re: invalid value for parameter "client_encoding": "ISO_8859_8" - Mailing list pgsql-admin

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@gmail.com>:

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@sss.pgh.pa.us>:

... 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