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

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


pgsql-general by date:

Previous
From: "nelma"
Date:
Subject: cursor
Next
From: kochinc@yahoo.com (Kochin Chang)
Date:
Subject: Re: 7.3.2, pam, on Linux 2.4.18-18.7.x i686