Обсуждение: LOCALE settings

Поиск
Список
Период
Сортировка

LOCALE settings

От
"Tomas Lehuta"
Дата:
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