Thread: LOCALE settings

LOCALE settings

From
"Tomas Lehuta"
Date:
Hello,
I've got problems using my native language locale with PostgreSQL.. i.e. bad
sorting order and incorrect special character types.

Is it possible to change locale settings of any existing database. Or do I
have to set locale env variables ONLY before 'initdb' for PostgreSQL to use
it? Then how could I use different locale settings for different databases?
Do I really have to dump all databases, re-initdb with desired locale (which
was not set after installing pgsql) and restore them all back?

Thanx for any help

regards

Tomas Lehuta