Re: CREATE COLLATION to match pg_collation data

rihad <rihad@mail.ru> writes:
> Hi, since pg_import_system_collations() that would solve all this
> doesn't exist in 9.6.x, is there a way to I properly map it to a CREATE
> COLLATE call? Specifically I need to have this collation (from 10.x) in
> 9.6.x so it works on FreeBSD:

>          collname        | collnamespace | collowner | collprovider |
> collencoding |    collcollate    | collctype     | collversion
>
------------------------+---------------+-----------+--------------+--------------+-------------------+-------------------+-------------
>   az-x-icu               |            11 |        10 | i           
> |           -1 | az                | az                | 153.88.34

That's an ICU collation, so you're out of luck: there is no ICU
support in 9.6.

            regards, tom lane