Обсуждение: Migrating LATIN1 dump to UNICODE db

Hello

We are currently running a pg 7.3.2 db on a linux system, the database we
are using has been created using '-e LATIN1' encoding.
Now we are in need of moving its contents to a pg database created using
UNICODE encoding (for our new customers using foreign languages).

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 ?

Thanks for your support

Laurent Perez

Laurent Perez <downloader@free.fr> 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