Re: Database encoding

From: gabriele(dot)bartolini(at)2ndquadrant(dot)it
To: pgsql-it-generale(at)postgresql(dot)org
Subject: Re: Database encoding
Date: 2010-03-26 18:33:18
Message-ID: 4BACFDEE.8010907@2ndQuadrant.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-it-generale

Salve Stefan,

purtroppo non è possibile cambiare con un comando del tipo "ALTER
DATABASE" l'encoding di un database. Deve per forza di cose esportare e
reimportare i dati.

A presto,
Gabriele

Stefan Mutschlechner ha scritto:
>
>
>
>
>
>
>
>
> Il mio database ha win1252 come encoding.
>
>
>
> -- Database: utsdb
>
>
>
> -- DROP DATABASE utsdb;
>
>
>
> CREATE DATABASE utsdb
>
> WITH OWNER = postgres
>
> ENCODING = 'WIN1252';
>
>
>
>
>
> Come faccio a metterlo su UTF8 senza recrearlo???
>
>
>
>
>
> P. Elet. Ind. Stefan Mutschlechner
>
> Chief of control engineering department
>
> T +39 340 71 51 857
>
> E s(dot)mutschlechner(at)ts-energygroup(dot)com
> <mailto:s(dot)mutschlechner(at)ts-energygroup(dot)com>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *P. Elet. Ind. Stefan Mutschlechner*
> Chief of control engineering department
> T +39 340 71 51 857* **
> *E s(dot)mutschlechner(at)ts-energygroup(dot)com
> <mailto:s(dot)mutschlechner(at)ts-energygroup(dot)com>* *
>
>
>
>
>
> *B.T.S. ITALIA* srl/GmbH
> Via S. Lorenzo, 34 St. Lorenznerstrasse
> I-39031 Brunico/Bruneck (BZ)
>
> T +39 0474 37 01 19
> F +39 0474 55 28 36
> P.IVA: 02590590218
>
> I www.ts-energygroup.com <http://www.ts-energygroup.com>*
> **
>
> *****
>
>
>
>
>
>
>

--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it

In response to

Browse pgsql-it-generale by date

  From Date Subject
Next Message gabriele.bartolini 2010-10-05 19:54:21 Aggiornamenti di sicurezza e ... addio PostgreSQL 7.4 e 8.0!
Previous Message Stefan Mutschlechner 2010-03-26 17:15:39 Database encoding