pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kasia Tuszynska <ktuszynska@esri.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: how to check locale of a cluster?
Date: Wed, 18 Feb 2009 20:05:05 -0500
Message-ID: <28677.1235005505@sss.pgh.pa.us> (raw)
In-Reply-To: <232B5217AD58584C87019E8933556D11011E3B7760@redmx2.esri.com>
References: <de3f3b06f55e4f88b0ced132435bcd96@webmail.zmi.at>
	<0b99ef815980dac4a445e1eb1da0d130@webmail.zmi.at>
	<dcc563d10902181354m5bfe6a14n1570c911ba26764f@mail.gmail.com>
	<232B5217AD58584C87019E8933556D11011E3B7760@redmx2.esri.com>

Kasia Tuszynska <ktuszynska@esri.com> 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

view thread (2+ messages)

Message-ID: <28677.1235005505@sss.pgh.pa.us>
Permalink:  ../28677.1235005505@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/28677.1235005505@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ktuszynska@esri.com
  Subject: Re: how to check locale of a cluster?
  In-Reply-To: <28677.1235005505@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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