Re: Migrating LATIN1 dump to UNICODE db - Mailing list pgsql-general

From Tom Lane
Subject Re: Migrating LATIN1 dump to UNICODE db
Date
Msg-id 2895.1053832311@sss.pgh.pa.us
Whole thread Raw
In response to Migrating LATIN1 dump to UNICODE db  (Laurent Perez <downloader@free.fr>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: network problems: -h flag not working properly
Next
From: "Vincent Hikida"
Date:
Subject: Re: plpgsql recursion