Quick Links

how can I find out the numeric directory name of each database in PostgreSQL 8.3

From:	Justin Yao <justin(at)snooth(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	how can I find out the numeric directory name of each database in PostgreSQL 8.3
Date:	2008-09-25 14:16:46
Message-ID:	48DB9D4E.2030705@snooth.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

Responses

Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3 at 2008-09-25 14:40:41 from Tino Wildenhain
Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3 at 2008-09-25 15:02:45 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jeff Amiel	2008-09-25 14:24:04	The planner hates me.
Previous Message	Louis-David Mitterrand	2008-09-25 14:13:31	group by error message?