| From: | rihad <rihad(at)mail(dot)ru> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | CREATE COLLATION to match pg_collation data |
| Date: | 2019-01-12 07:19:37 |
| Message-ID: | 94b6ba68-3f7e-d205-d009-219fce1318a6@mail.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2019-01-12 13:38:58 | Re: insert into: NULL in date column |
| Previous Message | Ricardo Martin Gomez | 2019-01-12 01:52:54 | Re: insert into: NULL in date column |