Re: Server locale?

On Mon, Oct 07, 2002 at 10:08:47PM +1000, Martijn van Oosterhout wrote:
> On Mon, Oct 07, 2002 at 09:28:16AM +0200, Karel Zak wrote:
> > On Sat, Oct 05, 2002 at 08:39:39PM -0400, Tom Lane wrote:
> > > Martijn van Oosterhout <kleptog(at)svana(dot)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.
>
> This must be a 7.3 thing. My 7.2.1 doesn't seem to support it. In any case,
> it seems that until recently there was no way of finding out, right?
> Short of accessing the backend directly.

Right, it's in 7.3.

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz