I don't know if you can alter the encoding of an existing database.
But you can change the client encoding by:
set client_encoding to 'UNICODE'
> X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
> content-class: urn:content-classes:message
> Subject: [GENERAL] Converting database-encoding from SQL_ASCII to UNICODE?????
> Date: Fri, 12 Sep 2003 11:54:40 +0200
> X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
> X-MS-Has-Attach:
> X-MS-TNEF-Correlator:
> Thread-Topic: Converting database-encoding from SQL_ASCII to UNICODE?????
> Thread-Index: AcN5E+KXB8tDpbN5TjmKLpvEOc40LA==
> From: "Amin Schoeib" <aschoeib@4tek.de>
> To: <pgsql-general@postgresql.org>
> X-Virus-Scanned: by amavisd-new at postgresql.org
> X-Mailing-List: pgsql-general
>
> Hi,
> I have a database with encoding SQL_ASCII.
> Now I need to convert the encoding to UNICODE.
> Can somebody tell me how I can do that????
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel. +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>
