/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

8 votes377 views2 answers
Pyenv install latest version
Shell/Bash
2 votes358 views2 answers
Create file linux
Shell/Bash
2 votes369 views2 answers
Aws cli s3 list buckets
Shell/Bash
0 vote332 views1 answer
Unzip in folder
Shell/Bash
1 vote349 views1 answer
Install amplify cli on mac
Shell/Bash
-1 vote371 views1 answer
A2ensite example.
Shell/Bash
9 votes327 views5 answers
Get all branches from remote
Shell/Bash
0 vote346 views1 answer
How to install gatsby gatsby-plugin-manifest
Shell/Bash
24 votes350 views4 answers
Uncompress tar.xz linux
Shell/Bash
0 vote362 views1 answer
Give names to ips on local machine ubuntu
Shell/Bash