/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 vote157 views1 answer
How to show lines on cat command
Shell/Bash
1 vote217 views2 answers
Port 80 in use by "unable to open process" with pid 4!
Shell/Bash
0 vote141 views1 answer
Libgnome-keyring-dev
Shell/Bash
7 votes181 views2 answers
Selenium install
Shell/Bash
0 vote164 views1 answer
Install node js redhat 8
Shell/Bash
1 vote170 views1 answer
Exec user process caused: exec format error
Shell/Bash
0 vote153 views1 answer
Batch set from file
Shell/Bash
0 vote190 views1 answer
Ubuntu wifi drivers realtek
Shell/Bash
0 vote133 views1 answer
Grepper kill a server
Shell/Bash
72 votes178 views6 answers
Unzip tar.gz
Shell/Bash