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 Peter Eisentraut
Subject Re: How to create database with default system locale is set to et_EE.UTF-8
Date
Msg-id 1324653796.5235.0.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: How to create database with default system locale is set to et_EE.UTF-8  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to create database with default system locale is set to et_EE.UTF-8
List pgsql-general
Tree view 
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.

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: "Andrus"
Date:
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8