Request a Demo
Home   >   mailing lists

Re: PQexecPrepared() question - Mailing list pgsql-general

From Igor Korot
Subject Re: PQexecPrepared() question
Date
Msg-id CA+FnnTzE34VJWR7xkymaKEwXiiQ8j3o03m0+qcQsRr2JkRQLwQ@mail.gmail.com
Whole thread Raw
In response to Re: PQexecPrepared() question  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: PQexecPrepared() question
Re: PQexecPrepared() question
List pgsql-general
Tree view
Hi,

On Tue, Dec 16, 2025 at 11:32 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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

pgsql-general by date:

Previous
From: Kris Deugau
Date:
Subject: Re: Record last SELECT on a row?
Next
From: "David G. Johnston"
Date:
Subject: Re: PQexecPrepared() question