Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
