/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

0 vote275 views1 answer
Generate guid in linux
Shell/Bash
0 vote306 views1 answer
Install imblearn
Shell/Bash
1 vote276 views1 answer
How to search all subfolders in linux for file
Shell/Bash
6 votes271 views1 answer
Bash if then else one line
Shell/Bash
13 votes325 views3 answers
How to get rid of local git repository
Shell/Bash
2 votes264 views3 answers
Install openjdk 11 ubuntu
Shell/Bash
95 votes242 views6 answers
Docker delete all images
Shell/Bash
2 votes245 views1 answer
Linux install figlet
Shell/Bash
0 vote277 views1 answer
Cannot remove file from trash
Shell/Bash
1 vote253 views1 answer
How to install yum in ubuntu
Shell/Bash