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