pg_database encoding again - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject pg_database encoding again
Date
Msg-id 122d01c328ac$56c828b0$6500a8c0@fhp.internal
Whole thread Raw
Responses Re: pg_database encoding again  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi Guys,

I really need a solution to this one :(

What is the encoding of the database names in the pg_database table?  As far
as I can tell, each row is saved in the encoding of the database from which
it is created?  In my application, the actual names change from gobbledygook
to proper japanese or russian say, as I change the encoding of the page
through each database encoding.

How on earth can I display all the names at once?  Is it even possible?
What if I go:

SET CLIENT_ENCODING TO 'UNICODE';
SELECT * FROM pg_database;

That doesn't really seem to work that well though...

Chris



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Table-driven SHOW (was Re: Are we losing momentum?)
Next
From: Bruce Momjian
Date:
Subject: Re: default locale considered harmful? (was Re: [GENERAL]