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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
