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>