Postgres Pro
Downloads
Home   >   mailing lists

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

From CoL
Subject Re: pg_dumpall and convert from LATIN1 to UTF-8?
Date
Msg-id c1n6o8$1ms7$1@news.hub.org
Whole thread Raw
In response to pg_dumpall and convert from LATIN1 to UTF-8?  (someone@arbitrary.org (Joseph))
List pgsql-novice
Tree view 
hi,

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?

try function convert (and check CREATE CONVERSION)

c.

pgsql-novice by date:

Previous
From: tully
Date:
Subject: Column Headings using Comment?
Next
From: Adelaide Yip
Date:
Subject: Cannot insert a duplicate key into unique index