On Sat, Dec 12, 2009 at 6:32 AM, Nando67 <xxx.yyy@xxxxxx> wrote: > I installed postgresql by pacman (i'm using an ArchLinux Distr) > the default encoding of template1 is SQL_ASCII, i want to change this > one with UTF8 encoding > > i try to use ALTER DATABASE but this statemanent hasn't the clause > encoding (while the CREATE DATABASE has it) so i can't modify the > template1 db by this one. I think you'll have to drop it and then create database with template0 as the template and set encoding then. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
