Skip to content

Latest commit

 

History

History
26 lines (19 loc) · 698 Bytes

SQL - PostgreSQL - Set Default UTF8 Encoding.md

File metadata and controls

26 lines (19 loc) · 698 Bytes

SQL - PostgreSQL - Set Default UTF8 Encoding

Source: https://gist.github.com/katylava/765188

UPDATE pg_database SET datistemplate=FALSE WHERE datname='template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH owner=postgres template=template0 encoding='UTF8';
UPDATE pg_database SET datistemplate=TRUE WHERE datname='template1';

Appendix: Links

Backlinks:

list from [[SQL - PostgreSQL - Set Default UTF8 Encoding]] AND -"Changelog"