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