/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

0 vote280 views1 answer
Python3 GIVINGSTORM.py -n Windows-Upgrade -p b64 encoded payload -c amazon.com/c2/domain HTA Example
Shell/Bash
1 vote204 views1 answer
Install dirsearch
Shell/Bash
0 vote194 views1 answer
Start new git repo from project
Shell/Bash
28 votes199 views4 answers
List all users linux
Shell/Bash
0 vote194 views1 answer
How to acess folder with space in name in terminal
Shell/Bash
0 vote194 views1 answer
Bash add comma to end of line
Shell/Bash
0 vote245 views1 answer
Install hyper-v Windows 10 Home
Shell/Bash
30 votes180 views4 answers
Beautifulsoup4 install
Shell/Bash
0 vote184 views1 answer
Du kan fixa tillbaka det med hjälp av GIT
Shell/Bash
0 vote192 views1 answer
Notepad++ convert lf to crlf
Shell/Bash