pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedChanging the encoding of the database on the fly
2+ messages / 2 participants
[nested] [flat]
* Changing the encoding of the database on the fly
@ 2006-05-31 13:35 Michael Kichanov <mike@inar.ru>
0 siblings, 1 reply; 2+ messages in thread
From: Michael Kichanov @ 2006-05-31 13:35 UTC (permalink / raw)
To: pgsql-admin
Hi All!
Can i change the encoding of the database with "update pg_database set encoding= where datname="
without any problem with DB integrity?
Thanx in advance!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Changing the encoding of the database on the fly
@ 2006-05-31 14:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Michael Kichanov <mike@inar.ru>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2006-05-31 14:43 UTC (permalink / raw)
To: Michael Kichanov <mike@inar.ru>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-31 14:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-31 13:35 Changing the encoding of the database on the fly Michael Kichanov <mike@inar.ru>
2006-05-31 14:43 ` Tom Lane <tgl@sss.pgh.pa.us>
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