Re: postgresql encoding

To: theal@pace2020.com
Cc: "Debian-User (E-mail)" <debian-user@lists.debian.org>
Subject: Re: postgresql encoding
From: Oliver Elphick <olly@lfix.co.uk>
Date: Mon, 17 Oct 2005 18:55:46 +0100
Message-id: <[🔎] 1129571746.8878.36.camel@linda.lfix.co.uk>
Reply-to: olly@lfix.co.uk
In-reply-to: <[🔎] 009d01c5d334$ffb80fa0$7001a8c0@oceania>
References: <[🔎] 009d01c5d334$ffb80fa0$7001a8c0@oceania>

On Mon, 2005-10-17 at 12:08 -0400, Tony Heal wrote:
> I have just upgraded my distro from woody to sarge and postgresql's encoding
> got messed up. Is there a way to change the encoding of a database without
> dumping and recreating it? I also need to change the default decoding of
> postgresql. It is set to SQL_ASCII and I want to change it to UNICODE

No.  You have to dump and reload.
-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html

Reply to:

References:
- postgresql encoding
  - From: "Tony Heal" <theal@pace2020.com>

Prev by Date: Re: apt-0.6 off line usage
Next by Date: Cups and smbspool
Previous by thread: postgresql encoding
Next by thread: Re: postgresql encoding
Index(es):
- Date
- Thread