Creating an UTF-8 postgresql database template

gistfile1.sql

update pg_catalog.pg_database set datistemplate = false where datname = 'template1';
drop database template1;
create database template1 template template0 encoding 'utf8' lc_collate 'fr_FR.utf8' lc_ctype 'fr_FR.utf8';
update pg_catalog.pg_database set datistemplate = true where datname = 'template1';