I am trying to create collation on windows using default POSIX collation with pgAdmin3 but I am getting error as shown in screenshot, Can someone suggest how to fix this?
Syntax:
CREATE COLLATION public.test from pg_catalog."POSIX";
Error:
ERROR: could not create locale "POSIX". No error
(Refer screenshot for more information.)
On Postgres website, It is mentioned that POSIX is available on all platform.
On all platforms, the collations named default, C, and POSIX are available. Additional collations may be available depending on operating system support.
