Re: Change empty database from ASCII to UTF-8 encoded

If it's not important, I'll just drop and re-create it. :)

Thanks

Thom

2009/1/14 Raymond O'Donnell <rod(at)iol(dot)ie>

> 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(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>