How to Change collate & ctype for an existing database?

From: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to Change collate & ctype for an existing database?
Date: 2019-12-13 08:56:48
Message-ID: BY5PR01MB58437AB6BCA55E54A99282C09B540@BY5PR01MB5843.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

How we can change the Collate & Ctype from "c" to "C.UTF-8" on existing production database.

SELECT datcollate FROM pg_database WHERE datname='wwkidbt';

datcollate

------------

C
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit

Please advice about the below method:

update pg_database set datcollate='C.UTF-8', datctype='C.UTF-8' where datname='wwkidbt';

Is there any impact on data/corruption if we do via update command ?

Thanks,

Daulat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2019-12-13 09:23:30 Re: How to Change collate & ctype for an existing database?
Previous Message Michael Paquier 2019-12-13 06:50:29 Re: wait event docs