Re: [GENERAL] How to add new Collation language - Mailing list 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