/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

18 votes119 views6 answers
Push to github
Shell/Bash
1 vote99 views1 answer
How to use openvpn linux terminal
Shell/Bash
32 votes91 views5 answers
Chocolatey installation
Shell/Bash
0 vote139 views1 answer
Git log show diff
Shell/Bash
9 votes104 views6 answers
How to kill a process in linux
Shell/Bash
0 vote94 views1 answer
Powershell file already exists
Shell/Bash
0 vote98 views1 answer
How to install wireshark on fedora
Shell/Bash
0 vote136 views1 answer
Change ratio vmware ubuntu
Shell/Bash
1 vote106 views1 answer
Sum variables shell
Shell/Bash
0 vote98 views1 answer
Go download all packages
Shell/Bash