Re: 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: Tino Wildenhain <tino(at)wildenhain(dot)de>
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:43:50
Message-ID: 48DBA3A6.9020205@snooth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

nothing special, just curious about it.
I suppose it should be able to be located by SQL.

Justin

Tino Wildenhain wrote:
> 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-09-25 15:01:08 Re: group by error message?
Previous Message Tino Wildenhain 2008-09-25 14:40:41 Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3