CREATE COLLATION to match pg_collation data
От | rihad |
---|---|
Тема | CREATE COLLATION to match pg_collation data |
Дата | |
Msg-id | 94b6ba68-3f7e-d205-d009-219fce1318a6@mail.ru обсуждение исходный текст |
Ответы |
Re: CREATE COLLATION to match pg_collation data
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: