Skip to content

Instantly share code, notes, and snippets.

@thanatos

thanatos/utf8-template1.sql

Created October 2, 2014 19:00
Show Gist options
  • Save thanatos/62f85046777545c05dad to your computer and use it in GitHub Desktop.
Save thanatos/62f85046777545c05dad to your computer and use it in GitHub Desktop.
Download ZIP
Make PosgreSQL's "template1" database UTF-8
Raw
utf8-template1.sql
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF-8';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
GRANT CONNECT ON DATABASE template1 TO PUBLIC;
REVOKE TEMPORARY ON DATABASE template1 FROM PUBLIC;
\c template1
VACUUM FREEZE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment