Migrating LATIN1 dump to UNICODE db

From: Laurent Perez <downloader(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Migrating LATIN1 dump to UNICODE db
Date: 2003-05-20 12:17:11
Message-ID: 5.0.2.1.2.20030520141040.02fe74c0@pop3.free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-05-20 12:41:15 Re: PRIMARY KEYS
Previous Message Martijn van Oosterhout 2003-05-20 12:15:14 Having problems with anoncvs