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

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Justin Yao <justin(at)snooth(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3
Date: 2008-09-25 14:40:41
Message-ID: 48DBA2E9.9000800@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Justin Yao wrote:
> 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?

What would you do with that name once you have it?

Tino

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Yao 2008-09-25 14:43:50 Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3
Previous Message Jeff Amiel 2008-09-25 14:24:04 The planner hates me.