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.