how to check locale of a cluster?

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: how to check locale of a cluster?
Date: 2009-02-19 00:48:02
Message-ID: 232B5217AD58584C87019E8933556D11011E3B7760@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everybody,

I am comparing selection results between postgres clusters on RHEL4 and Windows Server 2003.

The query is:
select count(*)from schema.table where route < 'Interstate 12'
on the RHEL machine the result has: 102 records
on the windows machine the result has: 586 records
the entire table has 687 records

On both clusters the column route is of type character varying (40)
On both clusters the server encoding is UTF8 - which I can see in pgAdminIII or by querying pg_database

I would like to figure out if the locale on both clusters is the same, because if the locales are different that would explain the different result sets for the same query.

Does anyone know how to check the locale of a cluster?

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."
I do not have a contrib folder on either machine, I suppose that I could go install it but is there an easier way?

Thank you,
Sincerely,
Kasia

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-02-19 01:05:05 Re: how to check locale of a cluster?
Previous Message Scott Marlowe 2009-02-18 21:54:28 Re: 8.3.5 broken after power fail