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 Tony