Skip site navigation (1) Skip section navigation (2)

Re: Changing encoding

From: "Marcelo Costa" <marcelojscosta(at)gmail(dot)com>
To: "Carol Walter" <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Changing encoding
Date: 2008-11-18 18:19:23
Message-ID: c13f2d590811181019q5cb1a768ocf5780083efcaab3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Carol

On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter <walterc(at)indiana(dot)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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-11-18 18:20:25
Subject: Re: Reliably determining whether the server came up
Previous:From: Tom LaneDate: 2008-11-18 18:07:16
Subject: Re: Is it safe to reset relfrozenxid without using vacuum?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group