pg_dumpall and convert from LATIN1 to UTF-8?

From: someone(at)arbitrary(dot)org (Joseph)
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dumpall and convert from LATIN1 to UTF-8?
Date: 2004-02-25 14:29:08
Message-ID: 4c8dd21a.0402250629.261e912d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Thanks,

Joseph

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message tully 2004-02-25 15:36:38 Column Headings using Comment?
Previous Message Rajan Bhide 2004-02-25 08:13:36 Linking issues with libpq