Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrus
Subject Re: How to create database with default system locale is set to et_EE.UTF-8
Date
Msg-id 68A48288559C46BEA809A029BC4FCBA7@dell2
Whole thread Raw
In response to Re: How to create database with default system locale is set to et_EE.UTF-8  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: How to create database with default system locale is set to et_EE.UTF-8
List pgsql-general
Tree view 
>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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8
Next
From: Peter Eisentraut
Date:
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8