update database collation in postgresql
snippet in sql

update database collation in postgresql

user7647

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