Re: pg_dump and client_encoding

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jan Poslusny <pajout(at)gingerall(dot)cz>, PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump and client_encoding
Date: 2004-01-06 11:58:28
Message-ID: 200401061258.28059.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam 2004-01-06 13:02:07 create template database
Previous Message Greg Sabino Mullane 2004-01-06 11:58:04 Re: PostgreSQL speakers needed for OSCON 2004