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 15:23:16
Message-ID: 1324653796.5235.0.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On tor, 2011-12-22 at 18:29 +0200, Andrus wrote:
> How to force command
>
> CREATE DATABASE <yourdbname> TEMPLATE = template0
>
> to use et_EE.UTF-8 locale by default ?

If you don't want to re-initdb, you could just update the datctype and
datcollate columns of pg_database for template0.

If you want to re-initdb, check the pg_createcluster man page on Debian.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2011-12-23 15:26:08 Re: How to create database with default system locale is set to et_EE.UTF-8
Previous Message Adrian Klaver 2011-12-23 15:20:36 Re: How to create database with default system locale is set to et_EE.UTF-8