/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

3 votes176 views2 answers
Fedora install snapd
Shell/Bash
0 vote166 views1 answer
Relead ngix
Shell/Bash
0 vote178 views1 answer
Git global settings ssh
Shell/Bash
1 vote164 views1 answer
Serial number linux
Shell/Bash
0 vote172 views1 answer
Install readline-sync
Shell/Bash
0 vote183 views1 answer
Can't connect to IBus.
Shell/Bash
9 votes130 views1 answer
Git fatal: the remote end hung up unexpectedly
Shell/Bash
2 votes206 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
Shell/Bash
0 vote159 views1 answer
Ignore .DS_store when uploading to s3 using shell
Shell/Bash
0 vote181 views1 answer
How to install linux headers on arch
Shell/Bash