Update database collation in postgresql

January 21, 2021 by Tony A. Comments are closed

update database collation in postgresql

update pg_database set datcollate='POSIX.UTF-8', datctype='POSIX.UTF-8' where datname='databasename';