X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C9CB5D9B1E for ; Mon, 10 Oct 2005 05:34:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87064-04 for ; Mon, 10 Oct 2005 08:34:19 +0000 (GMT) Received: from antivirus.unimo.it (antivirus.unimo.it [155.185.1.3]) by svr1.postgresql.org (Postfix) with ESMTP id E932DD9AE2 for ; Mon, 10 Oct 2005 05:34:19 -0300 (ADT) Received: from [155.185.48.190] (fluca.ing.unimo.it [155.185.48.190]) by antivirus.unimo.it (8.12.11/8.12.11) with ESMTP id j9A8YKiG009285 for ; Mon, 10 Oct 2005 10:34:20 +0200 Message-ID: <434A2792.1070106@infinito.it> Date: Mon, 10 Oct 2005 10:34:26 +0200 From: Luca Ferrari User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: character problem References: <4349106C.6080206@infinito.it> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-milter on antivirus (http://amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.516 required=5 tests=[FROM_ENDS_IN_NUMS=0.516] X-Spam-Level: X-Archive-Number: 200510/102 X-Sequence-Number: 19174 Hannes Dorbath's cat, on 10/10/2005 9.28, walking on the keyboard wrote: > The client encoding can be set anytime, to change the cluster LOCALE or > database encoding you need to initDB + dump and restore AFAIK. Do you mean dumping the database, destroying it and then recreating it? I'm sorry, but I'm still new in postgresql, thus it is not clear if meant that or another trick I don't know. Thanks, Luca -- Luca Ferrari fluca1978@infinito.it