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@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.
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.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
