Postgres Pro
Downloads
Home   >   mailing lists

pg_dumpall and convert from LATIN1 to UTF-8? - Mailing list pgsql-novice

From someone@arbitrary.org (Joseph)
Subject pg_dumpall and convert from LATIN1 to UTF-8?
Date
Msg-id 4c8dd21a.0402250629.261e912d@posting.google.com
Whole thread Raw
Responses Re: pg_dumpall and convert from LATIN1 to UTF-8?  (CoL <col@mportal.hu>)
Re: pg_dumpall and convert from LATIN1 to UTF-8?  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: joseph speigle
Date:
Subject: Re: installing pgsql
Next
From: William Bradley
Date:
Subject: su postgres password question.