/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

4 votes209 views3 answers
Mac run a shell script
Shell/Bash
0 vote213 views1 answer
Show file format snowflake
Shell/Bash
1 vote203 views1 answer
Get ubuntu version information
Shell/Bash
0 vote217 views2 answers
Kubectl patch annotation
Shell/Bash
62 votes194 views6 answers
Linux install pip
Shell/Bash
2 votes250 views1 answer
Add token to cli git
Shell/Bash
30 votes186 views3 answers
Pypy install matplotlib
Shell/Bash
11 votes193 views5 answers
Pm2 run
Shell/Bash
0 vote193 views1 answer
Firewall-cmd remove port
Shell/Bash
11 votes193 views3 answers
Move all files from one directory to another
Shell/Bash