Re: Adding new collations after pg_upgrade?

On 01/06/2019 07:57 PM, rihad wrote:
> On 01/06/2019 07:51 PM, Tom Lane wrote:
>> rihad <rihad@mail.ru> writes:
>>> Hi. on a freshly installed 10.6 I can see all ICU collations added in
>>> pg_collation schema. Is there a way to have them for an existing
>>> database cluster?
>> There's a function called something like pg_import_system_collations.
>> See documentation.
>
> Thanks a lot!
>
> postgres=# select pg_import_system_collations('pg_catalog');
>  pg_import_system_collations
> -----------------------------
>                          798
> (1 row)
>
> postgres=# select pg_import_system_collations('pg_catalog');
>  pg_import_system_collations
> -----------------------------
>                            0
> (1 row)

Oops, I meant schema pg_collation )
>
>
>>
>>             regards, tom lane
>> .
>>
>