Postgres Pro
Downloads
Home   >   mailing lists

Re: Server locale? - Mailing list pgsql-general

From Tom Lane
Subject Re: Server locale?
Date
Msg-id 6599.1033864779@sss.pgh.pa.us
Whole thread Raw
In response to Server locale?  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Server locale?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Tree view 
Martijn van Oosterhout <kleptog@svana.org> writes:
> Can you retrieve what the server is using for LOCALE settings? In
> particular, what the collate order is? It seems that my index is sorting
> case insensetively, and I can't see a reason why.

You can run contrib/pg_controldata (to become mainstream in 7.3 btw)
to see the server's LC_COLLATE and LC_CTYPE settings.

            regards, tom lane

pgsql-general by date:

Previous
From: Martin Weinberg
Date:
Subject: Re: multi-column btree index for real values
Next
From: Tom Lane
Date:
Subject: Re: Boolean output format