pg_dumpall and convert from LATIN1 to UTF-8?

Поиск
Список
Период
Сортировка
От someone@arbitrary.org (Joseph)
Тема pg_dumpall and convert from LATIN1 to UTF-8?
Дата
Msg-id 4c8dd21a.0402250629.261e912d@posting.google.com
обсуждение исходный текст
Ответы Re: pg_dumpall and convert from LATIN1 to UTF-8?  (CoL <col@mportal.hu>)
Re: pg_dumpall and convert from LATIN1 to UTF-8?  (Markus Bertheau <twanger@bluetwanger.de>)
Список pgsql-novice
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?

Thanks,

Joseph

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

Предыдущее
От: joseph speigle
Дата:
Сообщение: Re: installing pgsql
Следующее
От: William Bradley
Дата:
Сообщение: su postgres password question.