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

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

From: CoL <col(at)mportal(dot)hu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dumpall and convert from LATIN1 to UTF-8?
Date: 2004-02-27 10:39:11
Message-ID: c1n6o8$1ms7$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

pgsql-novice by date

Next:From: Paul MakepeaceDate: 2004-02-27 13:17:57
Subject: UPDATE FROM syntax
Previous:From: Adelaide YipDate: 2004-02-25 17:00:39
Subject: Cannot insert a duplicate key into unique index

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