Re: how can i change encoding in template1 DB?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Nando67 <xxx(dot)yyy(at)zzz(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how can i change encoding in template1 DB?
Date: 2009-12-12 19:41:49
Message-ID: dcc563d10912121141xf222d99hecc84b58158b1a67@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-12-12 19:43:01 Re: how can i change encoding in template1 DB?
Previous Message zxo102 ouyang 2009-12-12 15:59:07 How to save the results of replace(split_part(trim(both ' ' from "vx6000__12channel"), '__', 2), 'channel', 'myChannel') in my query into a temp variable?