pg_database encoding again

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_database encoding again
Date: 2003-06-02 02:11:53
Message-ID: 122d01c328ac$56c828b0$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-06-02 02:32:12 Re: default locale considered harmful? (was Re: [GENERAL]
Previous Message Rod Taylor 2003-06-02 00:02:45 Re: Table-driven SHOW (was Re: Are we losing momentum?)