On 14/01/2009 19:14, Thom Brown wrote: > I've just noticed my "postgres" database is encoded in ASCII. Is there > any way to convert it to UTF-8? Is there any negative consequence to > dropping the database and recreating it? Like are there special hidden > tables or functions in there? AFAIK you can't convert it - you have to drop and recreate it. There's nothing special about the postgres database; it's just there to provide an initial connection point, so there'll be nothing in it unless you put it there. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
