Re: Which file belongs to which database? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Which file belongs to which database?
Date
Msg-id 3F2125A6.5795.DF71AAF@localhost
Whole thread Raw
In response to Which file belongs to which database?  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Which file belongs to which database?
List pgsql-general
On 25 Jul 2003 at 8:45, Thomas Kellerer wrote:
> just out of curiosity: how can I find out which files in the PG_DATA directory
> belong to which database/table?

There is a contrib module oid2name. Use that.

You can just find the oid of the object from catalog and search for that file.
That's the principle.

Bye
 Shridhar

--
But Captain -- the engines can't take this much longer!


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Which file belongs to which database?
Next
From: Karsten Hilbert
Date:
Subject: Re: Which file belongs to which database?