rihad <rihad@xxxxxxx> 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
