/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 vote179 views1 answer
How to execute script and pass a parameterin linux
Shell/Bash
1 vote199 views1 answer
Makefile parameter
Shell/Bash
0 vote205 views1 answer
Pull from github to local
Shell/Bash
71 votes233 views2 answers
How to install docker in ubuntu using terminal
Shell/Bash
0 vote195 views1 answer
Shorten terminal prompt linux
Shell/Bash
0 vote183 views1 answer
Run specific migration file django
Shell/Bash
1 vote183 views1 answer
Heroku standalone installation
Shell/Bash
1 vote206 views1 answer
To check the status of running process On Debian and Ubuntu
Shell/Bash
8 votes221 views1 answer
Find text in folder
Shell/Bash
0 vote188 views1 answer
Ls all subdirectories
Shell/Bash