Re: how to find DB names in Postgres 7.1?

Look in the contrib directory for oid2name.  This program will do what
you are looking for.

Limin Liu wrote:
> 
> In Postgres 7.1, ${PGDATA}/base contains directories named by
> numbers!!   They used to be database names.   If a user created a db,
> can the db admin know what is that db name (without sending any query to
> db server)?
> 
> I believe there must have some kind of mapping table exist.  Can anyone
> tell me where to find it?
> 
> Thanx for your help
> 
> LM.Liu
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

-- 
---------------------------------------------------
Randy Hall                    Great Bridge, LLC
Sr. Knowledge Engineer        253 Monticello Avenue
Red Hat Certified Engineer    Norfolk, VA 23410