Re: how can i change encoding in template1 DB?

On Sat, Dec 12, 2009 at 6:32 AM, Nando67 <xxx.yyy@zzz.it> 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.