Re: pg_dump and client_encoding - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pg_dump and client_encoding
Date
Msg-id 200401061258.28059.peter_e@gmx.net
Whole thread Raw
In response to pg_dump and client_encoding  (Jan Poslusny <pajout@gingerall.cz>)
Responses C API Documentation  (Karam Chand <karam_chand03@yahoo.com>)
List pgsql-general
Jan Poslusny wrote:
> I have following experience:
> After pg_dump mydb > db.out output contains one or more \connect -
> somebody, but client_encoding is not set. It causes restoration
> problems on  databases with different default client_encoding. I
> think client_encoding may be set after each \connect.

The client_encoding parameter specifies to the server what encoding the
client uses.  Presumably, that stays the same during one psql run.

Maybe you haven't set the client encoding at all?  Try setting the
environment variable PGCLIENTENCODING.  Else, please post a more
specific description of the symptoms of your problem.


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: release notes/Appendix E in documentation
Next
From: Bruno Wolff III
Date:
Subject: Re: Any way to have CREATEUSER privs without having all privs?