Re: encoding question

> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > What is the encoding of the database names in pg_database???
> 
> I suspect we do not have a consistent answer to that :-( ... it
> probably depends on which database you did CREATE DATABASE from ...

Right. Usually encodings for global tables such as pg_database are
same as template1 unless you explicitly specify the template
database. Since PostgreSQL does not allow tables where each row is
encoded differently(even the standard does allow that), you should use
characters that are common among all possible encodings for such
global tables. This means you could only use ASCII for database
names. Same thing can be said for user names.
--
Tatsuo Ishii