> Hi Everyone,
> I have used pg_dumpall on a database that was created with LATIN1
> encoding and has a whole bunch of messy latin1 data in it.
> I want to restore this data to a new db with UTF-8 encoding, with the
> data converted so the 8859-1 characters display properly.
> How should I go about doing this?
try function convert (and check CREATE CONVERSION)
In response to
pgsql-novice by date
|Next:||From: Paul Makepeace||Date: 2004-02-27 13:17:57|
|Subject: UPDATE FROM syntax|
|Previous:||From: Adelaide Yip||Date: 2004-02-25 17:00:39|
|Subject: Cannot insert a duplicate key into unique index|