Thread: How to Change collate & ctype for an existing database?
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
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