Re: Migrating LATIN1 dump to UNICODE db

Laurent Perez  writes:
> Is there some postgres-based tool to convert or reimport a LATIN1 textfile 
> dump (from a pg_dump cmd) into an UNICODE encoding database, or some kind 
> of built-in converter available ?

It should "just work" to pg_dump and reload.  Be careful that the reload
is done with the same pg_client_encoding setting that was used for the
dump.  PG will automatically translate between different client and
server encodings ... but you have to be sure to tell it the truth about
what the client side is using.

			regards, tom lane