how can I find out the numeric directory name of each database in PostgreSQL 8.3 - Mailing list pgsql-general

From Justin Yao
Subject how can I find out the numeric directory name of each database in PostgreSQL 8.3
Date
Msg-id 48DB9D4E.2030705@snooth.com
Whole thread Raw
Responses Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3  (Tino Wildenhain <tino@wildenhain.de>)
Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

In PostgreSQL 7.x, I can use SQL:
select datname, oid from pg_database
to find out the numeric directory name under $PGDATA/base for each
database. But it doesn't work for PostgreSQL 8.3.
Is there any way I can do it for 8.3?

Thanks,
--
Justin Yao

pgsql-general by date:

Previous
From: "Jeff Amiel"
Date:
Subject: The planner hates me.
Next
From: Tino Wildenhain
Date:
Subject: Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3