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