| 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 |