Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E107E6327A3 for ; Wed, 18 Feb 2009 21:05:19 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21622-03 for ; Wed, 18 Feb 2009 21:05:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 3C18363225E for ; Wed, 18 Feb 2009 21:05:13 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n1J155vd028678; Wed, 18 Feb 2009 20:05:05 -0500 (EST) To: Kasia Tuszynska cc: "pgsql-admin@postgresql.org" Subject: Re: how to check locale of a cluster? In-reply-to: <232B5217AD58584C87019E8933556D11011E3B7760@redmx2.esri.com> References: <0b99ef815980dac4a445e1eb1da0d130@webmail.zmi.at> <232B5217AD58584C87019E8933556D11011E3B7760@redmx2.esri.com> Comments: In-reply-to Kasia Tuszynska message dated "Wed, 18 Feb 2009 16:48:02 -0800" Date: Wed, 18 Feb 2009 20:05:05 -0500 Message-ID: <28677.1235005505@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/143 X-Sequence-Number: 31364 Kasia Tuszynska writes: > Does anyone know how to check the locale of a cluster? "show lc_collate" has worked since 7.4. > The documentation has yielded this " You can check the LC_COLLATE and LC_CTYPE settings of a database with the contrib/pg_controldata utility program." The docs have not said that since 7.3. I really hope that is not what you are running ... especially not on the Windows machine. regards, tom lane