Re: [ADMIN] what's the efficient/safest way to convert database character set ?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Date: 2013-10-20 19:22:07
Message-ID: 52642D5F.3030404@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-10-20 21:24:53 Re: Preserving the source code of views
Previous Message Bill Moran 2013-10-20 12:01:21 Re: Preserving the source code of views