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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>, <adrian(dot)klaver(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8
Date: 2011-12-23 15:32:35
Message-ID: 68A48288559C46BEA809A029BC4FCBA7@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2011-12-23 17:48:21 Re: How to create database with default system locale is set to et_EE.UTF-8
Previous Message Adrian Klaver 2011-12-23 15:27:44 Re: How to create database with default system locale is set to et_EE.UTF-8