On Sat, Oct 05, 2002 at 08:39:39PM -0400, Tom Lane wrote:
> 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.
and by "SHOW ALL" or SHOW LC_ [ COLLATE | ... ] commands too.
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz