Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Which file belongs to which database?
Date
Msg-id bfqjjt$2v2$1@main.gmane.org
Whole thread Raw
Responses Re: Which file belongs to which database?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Which file belongs to which database?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Hello all,

just out of curiosity: how can I find out which files in the PG_DATA directory
belong to which database/table?

I have looked through the documentation of the system catalogs, but couldn't
find any reference to that.

The field datpath in pg_database is empty in my system (7.2 on Windows and 7.3.1
on Linux)

Cheers
Thomas

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Can I turn the case sensitive off
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Which file belongs to which database?