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 COLLATIONname  (
    [ LOCALE =locale, ]
    [ LC_COLLATE =lc_collate, ]
    [ LC_CTYPE =lc_ctype  ]
)
CREATE COLLATIONname FROMexisting_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.

Reply via email to