How to find correct locale name for CREATE DATABASE

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to find correct locale name for CREATE DATABASE
Date: 2010-11-30 17:12:50
Message-ID: 8D35B2E43A6B4949864C987F088BC3B4@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tried in Debian ("PostgreSQL 9.0.1 on x86_64-pc-linux-gnu, compiled by
GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit") :

1. CREATE DATABASE "mydb" WITH TEMPLATE=template0
LC_COLLATE='Estonian_Estonia.1257' LC_CTYPE='Estonian_Estonia.1257'
OWNER="mydb_owner" ENCODING='UNICODE'

2. CREATE DATABASE "mydb" WITH TEMPLATE=template0 LC_COLLATE='et_EE.UTF-8'
LC_CTYPE='et_EE.UTF-8' OWNER="mydb_owner" ENCODING='UNICODE'

3. 2. CREATE DATABASE "mydb" WITH TEMPLATE=template0
LC_COLLATE='et_EE.UTF8'
LC_CTYPE='et_EE.UTF8' OWNER="mydb_owner" ENCODING='UNICODE'

in all cases same error

invalid locale name

occurs.

Questions:

1. How to find correct locale name for Estonian in Debian Linux ?
In Windows case (1) works.

2. How to create portable CREATE DATABASE command for estonian locale which
works in all operating systems?

3. Or how to detect OS from PostgreSql server and select correct Estonian
locale ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-11-30 17:17:29 Re: How to find correct locale name for CREATE DATABASE
Previous Message A J 2010-11-30 16:58:58 Extension for file management under postgres