Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group