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