CREATE COLLATION to match pg_collation data

[rihad <rihad@xxxxxxx>]

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

CREATE COLLATION name (
    [ LOCALE = locale, ]
    [ LC_COLLATE = lc_collate, ]
    [ LC_CTYPE = lc_ctype ]
)
CREATE COLLATION name FROM existing_collation

https://www.postgresql.org/docs/9.6/sql-createcollation.html


Can I just not use "create collation", and simply insert the new row as is?

Thanks for any tips.