Changing character set of existing databases

From: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
To: pgsql-admin(at)postgresql(dot)org
Subject: Changing character set of existing databases
Date: 2009-09-10 13:38:24
Message-ID: 4AA90150.4010803@lemail.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I made a mistake an got a character set in SQL_ASCII as the defaut
encoding type :

$ psql -l
List of databases
Name | Owner | Encoding
--------------+----------+-----------
cmp_crm | openerp | SQL_ASCII
cmp_crm_demo | openerp | SQL_ASCII
cmp_testcrm | openerp | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(6 rows)

I need to get them in UTF-8. ->
1) Can I modify these existing databases to switch them into UTF-8? How?
2) Can I modify the defaut character set to create further databases in
UTF-8 by default?

Thank you so much,
nm

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keller, Oliver 2009-09-10 13:42:48 FW: integer import problem
Previous Message Keller, Oliver 2009-09-10 09:37:15 integer import problem