| 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: | Whole Thread | Raw Message | 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 |