/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

1 vote329 views1 answer
Bashrc termina,
Shell/Bash
2 votes343 views2 answers
Linux view running jobs
Shell/Bash
-1 vote330 views1 answer
Ver ayuda de comandos en linux
Shell/Bash
0 vote343 views3 answers
Convert wsl to wsl2
Shell/Bash
5 votes297 views2 answers
Install the latest docker on ubuntu 20.04
Shell/Bash
0 vote372 views1 answer
Ubuntu dual monitor mouse flicker
Shell/Bash
2 votes362 views3 answers
Disable ufw
Shell/Bash
0 vote282 views2 answers
Raspberry pi ubuntu config
Shell/Bash
0 vote281 views1 answer
Bash: ng: command not found yarn
Shell/Bash
8 votes338 views4 answers
Install composer on ubuntu 20.04
Shell/Bash