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

From Thomas Kellerer
Subject Re: Which file belongs to which database?
Date
Msg-id bfqm80$gar$1@main.gmane.org
Whole thread Raw
In response to Re: Which file belongs to which database?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Which file belongs to which database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Shridhar Daithankar schrieb:

> 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
>

That easy ? :-)

Thanks for the information!

Cheers
Thomas



pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Which file belongs to which database?
Next
From: Jean-Christophe ARNU (JX)
Date:
Subject: plPython and restricted execution issues