Postgres Pro
Downloads
Home   >   mailing lists

Re: About pg_dump - Mailing list pgsql-sql

From Tom Lane
Subject Re: About pg_dump
Date
Msg-id 20281.1079020997@sss.pgh.pa.us
Whole thread Raw
In response to Re: About pg_dump  ("Rute Solipa" <rutes@eselx.ipl.pt>)
Responses Re: About pg_dump  (Daniel Henrique Alves Lima <email_daniel_h@yahoo.com.br>)
List pgsql-sql
Tree view 
"Rute Solipa" <rutes@eselx.ipl.pt> writes:
> it seems that the pg_dump command doesn't keep the encoding information.

As of 7.4.2 it does emit a SET client_encoding.

In prior releases, if you are manually creating the destination database
then you need to be careful to create it with the same encoding as before.
        regards, tom lane

pgsql-sql by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: randomized order in select?
Next
From: "scott.marlowe"
Date:
Subject: Re: designer tool connect to PostgreSQL