Postgres Pro
Downloads
Home   >   mailing lists

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

Change empty database from ASCII to UTF-8 encoded

From
"Thom Brown"
Date:
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?

Thanks

Thom

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

From
Raymond O'Donnell
Date:
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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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

From
"Thom Brown"
Date:
If it's not important, I'll just drop and re-create it. :)

Thanks

Thom

2009/1/14 Raymond O'Donnell <rod@iol.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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------