Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing the encoding of the database on the fly - Mailing list pgsql-admin

From Tom Lane
Subject Re: Changing the encoding of the database on the fly
Date
Msg-id 12252.1149086594@sss.pgh.pa.us
Whole thread Raw
In response to Changing the encoding of the database on the fly  (Michael Kichanov <mike@inar.ru>)
List pgsql-admin
Tree view 
Michael Kichanov <mike@inar.ru> writes:
> Can i change the encoding of the database with "update pg_database set encoding= where datname="
> without any problem with DB integrity?

No.  That's not going to magically fix your data to be correct in the
new encoding.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Averbukh Stella"
Date:
Subject: Re: Problem building initdb on sparc10
Next
From: "Sriram Dandapani"
Date:
Subject: autovacuum