Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> writes:
> Robert James wrote:
>> Thanks - I don't show any locale:
> ahm - you are running pg 8.2. There I think the + option is not
> available (\l+). So if you use a debian based system and installed it
> via the package manager apt or aptitude you could give this a try:
> /usr/lib/postgresql/8.2/bin/pg_controldata \
> /var/lib/postgresql/8.2/main/ |grep LC
Easier way is "SHOW LC_COLLATE" and "SHOW LC_CTYPE" ...
regards, tom lane