Re: Which file belongs to which database?

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Which file belongs to which database?
Date: 2003-07-25 07:12:14
Message-ID: 3F2125A6.5795.DF71AAF@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2003-07-25 07:30:20 Re: Which file belongs to which database?
Previous Message Karsten Hilbert 2003-07-25 07:07:54 Re: Which file belongs to which database?