/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

5 votes284 views1 answer
Add a cookie to curl
Shell/Bash
0 vote294 views1 answer
Fatal: 'upstream' does not appear to be a git repository
Shell/Bash
0 vote286 views1 answer
Docker-compose update code without using build again
Shell/Bash
0 vote288 views1 answer
How to install blackeye bash
Shell/Bash
0 vote295 views1 answer
Simulate keys with powershell
Shell/Bash
1 vote294 views1 answer
How to delete services in kubernetes
Shell/Bash
10 votes278 views2 answers
Angular create a service
Shell/Bash
0 vote306 views1 answer
How to check if automatic system updates are working on fedora
Shell/Bash
32 votes288 views2 answers
Print in shell script
Shell/Bash
0 vote304 views1 answer
Cannot connect to daemon at tcp:5037: Connection refused
Shell/Bash