Re: How to create database with default system locale is set to et_EE.UTF-8

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to create database with default system locale is set to et_EE.UTF-8
Дата
Msg-id 68A48288559C46BEA809A029BC4FCBA7@dell2
обсуждение исходный текст
Ответ на Re: How to create database with default system locale is set to et_EE.UTF-8  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: How to create database with default system locale is set to et_EE.UTF-8
Список pgsql-general
>If you don't want to re-initdb, you could just update the datctype and
>datcollate columns of pg_database for template0.

Thank you.
where to find sql update statement which does this ?
Is

update pg_database set datctype ='et_EE.UTF-8',   datcollate ='et_EE.UTF-8'

best for this ?

template0 is read-only, how to connect to and update it using pgAdmin ?

Andrus.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to create database with default system locale is set to et_EE.UTF-8
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: How to create database with default system locale is set to et_EE.UTF-8