/Shell/Bash/Postgres change deafult encode

Postgres change deafult encode

postgres@yourserver:~$ psql


UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF8';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
\c template1;
VACUUM FREEZE;

Source: grepper.com

Similar codes

11 votes187 views6 answers
Pip install discord.py
Shell/Bash
1 vote192 views2 answers
How to install cassandra
Shell/Bash
0 vote186 views1 answer
Git save changes
Shell/Bash
0 vote217 views1 answer
How to print output of a command to a file in linux
Shell/Bash
1 vote186 views1 answer
Installing g++ on ubuntu
Shell/Bash
3 votes182 views1 answer
Git update local repo from master
Shell/Bash
0 vote177 views3 answers
Awk convert first character to lowercase
Shell/Bash
28 votes193 views5 answers
Kubectl create namespace
Shell/Bash
7 votes212 views6 answers
Uninstall mongodb ubuntu
Shell/Bash
0 vote181 views1 answer
How to create new html file using cmd
Shell/Bash