/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 votes341 views3 answers
Powershell download file with progress
Shell/Bash
0 vote299 views1 answer
Cantidad de digitos
Shell/Bash
0 vote303 views1 answer
How to transfer data between computers
Shell/Bash
3 votes319 views1 answer
How to install sublime text on arch linux
Shell/Bash
1 vote306 views1 answer
Remove bar in browser in ubuntu
Shell/Bash
70 votes295 views5 answers
Install docker ubuntu 20
Shell/Bash
3 votes298 views3 answers
Adb screenrecord
Shell/Bash
0 vote316 views1 answer
Uninstall peazip linux
Shell/Bash
-1 vote283 views2 answers
Download putty for ubuntu
Shell/Bash
1 vote323 views2 answers
Check if service in running to a port in linux
Shell/Bash