Re: [GENERAL] How to add new Collation language

Поиск
Список
Период
Сортировка
От Rob Northcott
Тема Re: [GENERAL] How to add new Collation language
Дата
Msg-id AM3PR08MB0610FE95426043FFD4F2EF659B6F0@AM3PR08MB0610.eurprd08.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [GENERAL] How to add new Collation language  (rob stone <floriparob@gmail.com>)
Ответы Re: [GENERAL] How to add new Collation language  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
    

-----Original Message-----
From: rob stone [mailto:floriparob@gmail.com] 
Sent: 14 September 2017 13:38
To: Rob Northcott <Rob.Northcott@compilator.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to add new Collation language



On Thu, 2017-09-14 at 11:30 +0000, Rob Northcott wrote:
> How can I add a collation language to a Postgres server?
> Specifically, I want to create a new database with collation of 
> English_United Kingdom.1252 but the only options are C, Posix and 
> United States.
> Even if I select United Kingdom as the locale when installing Postgres 
> I still only have United States.
>  
> Am I missing something or is there a way to add the United Kingdom 
> collation?
>  
> This is Postgres 9.6 on Windows server 2012.  The server is Swedish, 
> and my user login is set to UK.


>>Hello,

>>initdb --locale=en_GB.UTF-8 . . . plus other init options as required.


Thanks for the reply.  When I try that I get the message "invalid locale name"

Rob

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: vinny
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] How to add new Collation language