Skip to content

Instantly share code, notes, and snippets.

💭
Looking for new job

Sachin Singh sachin87

💭
Looking for new job
Block or report user

Report or block sachin87

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View psql_encoding.sql
sudo su postgres
psql
update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8'
lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';
You can’t perform that action at this time.