Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] what's the efficient/safest way to convert database character set ? - Mailing list pgsql-general

From John R Pierce
Subject Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Date
Msg-id 52642D5F.3030404@hogranch.com
Whole thread Raw
In response to Re: [ADMIN] what's the efficient/safest way to convert database character set ?  ("Huang, Suya" <Suya.Huang@au.experian.com>)
Responses Re: [ADMIN] what's the efficient/safest way to convert database character set ?  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-general
Tree view 
On 10/20/2013 3:56 AM, Huang, Suya wrote:
> We stored ISO-8859-1, do we still need to use iconv to convert the file?

you should be able to do the dump specifying pg_dump
--encoding=iso-8559-1 then restore it to the utf8 database, and postgres
will do the conversion for you.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Preserving the source code of views
Next
From: Tom Lane
Date:
Subject: Re: Preserving the source code of views