Re: [GENERAL] How to add new Collation language

Поиск
Список
Период
Сортировка
От rob stone
Тема Re: [GENERAL] How to add new Collation language
Дата
Msg-id 1505392701.3727.1.camel@gmail.com
обсуждение исходный текст
Ответ на [GENERAL] How to add new Collation language  (Rob Northcott <Rob.Northcott@compilator.com>)
Ответы Re: [GENERAL] How to add new Collation language  (Rob Northcott <Rob.Northcott@compilator.com>)
Список pgsql-general

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.


HTH,
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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [GENERAL] a JOIN to a VIEW seems slow
Следующее
От: "Frank Millman"
Дата:
Сообщение: Re: [GENERAL] a JOIN to a VIEW seems slow