How to Change collate & ctype for an existing database?

Daulat Ram <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <BY5PR01MB58437AB6BCA55E54A99282C09B540@BY5PR01MB5843.prod.exchangelabs.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.