Database di template template1 con encoding utf8

Qui sotto una piccola tip per far si che il template1
abbia l'encoding uft8

psql (9.0.3)
Type "help" for help.
 
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
UPDATE 1
postgres=# \c template0
You are now connected to database "template0".
template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
UPDATE 1
template0=# drop database template1;
DROP DATABASE
template0=# create database template1 with template = template0 encoding = 'UTF8';
CREATE DATABASE
template0=# update pg_database set datistemplate = TRUE where datname = 'template1';
UPDATE 1
template0=# \c template1
You are now connected to database "template1".
template1=# update pg_database set datallowconn = FALSE where datname = 'template0';
UPDATE 1
 

 

Back to top

Privacy Policy | Project hosted by linuxtime.it | pgTheme is a Drupal 6.x Theme creato da Massimiliano Marini per PSQL.it
Original Theme Designed by tinysofa for The Official Site of PostgreSQL