Re: pg_dumpall and convert from LATIN1 to UTF-8?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Joseph <someone(at)arbitrary(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dumpall and convert from LATIN1 to UTF-8?
Date: 2004-02-29 09:50:37
Message-ID: 1078048236.1985.0.camel@yarrow.bertheau.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Срд, 2004-02-25 at 06:29 -0800, Joseph wrote:
> 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?

Pipe the dump through iconv.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message kynn 2004-02-29 22:05:51 Help! "alter table add column" hangs
Previous Message V i s h a l Kashyap @ [Sai Hertz And Control Systems] 2004-02-29 06:07:11 Re: Cannot insert a duplicate key into unique index