Re: Changing encoding - Mailing list pgsql-admin

From Marcelo Costa
Subject Re: Changing encoding
Date
Msg-id c13f2d590811181019q5cb1a768ocf5780083efcaab3@mail.gmail.com
Whole thread Raw
In response to Changing encoding  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Hi Carol

On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter <walterc@indiana.edu> wrote:
Hello,

I have some databases that are designated as "SQL_ASCII" encoding.  I need them to be "UTF-8".  I know that "SQL_ASCII" is really the absence of encoding.  Is there a way to do this?

Try use pg_dump on your ASCII database with option -E

ex.: pgdump -U user database -E UTF8 -f filename.sql


--
Marcelo Costa

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is it safe to reset relfrozenxid without using vacuum?
Next
From: Tom Lane
Date:
Subject: Re: Reliably determining whether the server came up