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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Andrus <kobruleht2(at)hot(dot)ee>
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 17:48:21
Message-ID: 1324662501.14547.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2011-12-23 18:47:14 Example of a pg_gethostname() function. Feedback?
Previous Message Andrus 2011-12-23 15:32:35 Re: How to create database with default system locale is set to et_EE.UTF-8