From: Marcelo Costa <marcelojscosta@gmail.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Changing encoding
Date: Tue, 18 Nov 2008 16:19:23 -0200
Message-ID: <c13f2d590811181019q5cb1a768ocf5780083efcaab3@mail.gmail.com> (raw)
In-Reply-To: <30BF2B35-C7AC-4743-99FA-C98BFCD372B6@indiana.edu>
References: <30BF2B35-C7AC-4743-99FA-C98BFCD372B6@indiana.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: marcelojscosta@gmail.com, walterc@indiana.edu
Subject: Re: Changing encoding
In-Reply-To: <c13f2d590811181019q5cb1a768ocf5780083efcaab3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox