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

On fre, 2011-12-23 at 17:32 +0200, Andrus wrote:
> >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 ?

add WHERE datname = 'template0'

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

pg_database is shared between all databases, so you can connect to any
database to do this.