Re: How to add new Collation language

-----Original Message-----
From: rob stone [mailto:floriparob(at)gmail(dot)com]
Sent: 14 September 2017 13:38
To: Rob Northcott <Rob(dot)Northcott(at)compilator(dot)com>; pgsql-general(at)postgresql(dot)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