Tom Lane wrote:
"Rute Solipa" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html