/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 vote138 views1 answer
Create github packages
Shell/Bash
0 vote184 views1 answer
Linux monitor outgoing https requests
Shell/Bash
0 vote140 views1 answer
Fit gnuplot error bars
Shell/Bash
1 vote140 views1 answer
Bash how to delete ^M at the end of every line
Shell/Bash
9 votes137 views2 answers
Kubectl completion zsh
Shell/Bash
50 votes147 views1 answer
Check the linux distribution
Shell/Bash
2 votes92 views1 answer
Ls get only file names
Shell/Bash
10 votes132 views3 answers
Powershell download file
Shell/Bash
8 votes163 views2 answers
Heroku ubuntu install
Shell/Bash
0 vote217 views1 answer
Powershell command to change minimum password length
Shell/Bash