Pawel Ziecina pziecina

pziecina / pgsql_change_template_1.sql

Created February 17, 2013 10:28 — forked from EmmanuelOga/pgsql_change_template_1.sql

	# 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';