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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
