-----Original Message----- From: rob stone [mailto:floriparob@xxxxxxxxx] Sent: 14 September 2017 13:38 To: Rob Northcott <Rob.Northcott@xxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
