Postgres Pro
Downloads
Home   >   mailing lists

how can i change encoding in template1 DB? - Mailing list pgsql-general

From Nando67
Subject how can i change encoding in template1 DB?
Date
Msg-id hg062i$2tu$1@nnrp.ngi.it
Whole thread Raw
Responses Re: how can i change encoding in template1 DB?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: how can i change encoding in template1 DB?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: how can i change encoding in template1 DB?  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
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.

how can i do it?

many thanks

nando

pgsql-general by date:

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