On Tue, 2025-12-16 at 21:53 -0800, Igor Korot wrote:
> Is there some default value for client_encoding?
The default value for a client connection is whatever the parameter
"client_encoding" was set to in the PostgreSQL server configuration.
Imagine following scenario:
I have 2 machines. One is running PG server on *nix. Second is my app on Windows.
An application starts for the first time.
What is “clientencoding in this case?
Thank you.
But that value can be overridden in several ways:
- explicitly by setting "client_encoding" in the connect string
- with the SQL statement SET by the client
- if the client has "client_encoding=auto", by the encoding set in
the client's environment
- by setting the PGCLIENTENCODING environment variable
Yours,
Laurenz Albe