X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 12D679FA5F0 for ; Wed, 31 May 2006 10:42:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05658-07 for ; Wed, 31 May 2006 10:42:06 -0300 (ADT) X-Greylist: delayed 00:06:19.895947 by SQLgrey- Received: from mix.inar.ru (mix.inar.ru [212.14.161.14]) by postgresql.org (Postfix) with ESMTP id 7A0149FA5DD for ; Wed, 31 May 2006 10:42:03 -0300 (ADT) Received: (from mike@localhost) by mix.inar.ru (8.8.5/8.8.5) id RAA11979 for pgsql-admin@postgresql.org; Wed, 31 May 2006 17:35:40 +0400 (MSK/MSD) Message-Id: <200605311335.RAA11979@mix.inar.ru> Subject: Changing the encoding of the database on the fly To: pgsql-admin@postgresql.org Date: Wed, 31 May 2006 17:35:40 +0400 (MSK/MSD) From: Michael Kichanov X-Mailer: ELM [version 2.4ME+ PL117 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/428 X-Sequence-Number: 21960 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!