| From: | Randy Hall <rhall(at)greatbridge(dot)com> |
|---|---|
| To: | Limin Liu <limin(at)pumpkinnet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to find DB names in Postgres 7.1? |
| Date: | 2001-03-06 22:10:02 |
| Message-ID: | 3AA5603A.14702393@greatbridge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando P. Schapachnik | 2001-03-06 22:35:41 | Re: interval question |
| Previous Message | Michelle Murrain | 2001-03-06 22:08:41 | Re: DELETE and efficiency |