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: | Raw Message | Whole Thread | 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 |