CREATE COLLATION to match pg_collation data

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.

Responses

Browse pgsql-general by date

  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