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

Поиск
Список
Период
Сортировка
От Markus Bertheau
Тема Re: pg_dumpall and convert from LATIN1 to UTF-8?
Дата
Msg-id 1078048236.1985.0.camel@yarrow.bertheau.de
обсуждение исходный текст
Ответ на pg_dumpall and convert from LATIN1 to UTF-8?  (someone@arbitrary.org (Joseph))
Список 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@bluetwanger.de>

В списке pgsql-novice по дате отправления:

Предыдущее
От: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Дата:
Сообщение: Re: Cannot insert a duplicate key into unique index
Следующее
От:
Дата:
Сообщение: Help! "alter table add column" hangs