"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