Re: Which file belongs to which database? - Mailing 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!