Skip to content

Instantly share code, notes, and snippets.

View pziecina's full-sized avatar

Paweł Zięcina pziecina

View GitHub Profile
# change postgresql template1 db encoding to utf8 (unicode) by dropping it and recreating from template0
UPDATE pg_database SET datistemplate=false WHERE datname='template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';