Re: Which files belong to which database? - Mailing list pgsql-novice

On Wed, 10 Sep 2003, Oliver Fromme wrote:

> Is there a way to find out which files in $PGDATA belong
> to which database?  I need that information for accounting
> purposes (users are billed per Gbyte of data).  In mysql

I believe the structure in general is:
base/
base/<database oid>
base/<database oid>/<object relfilenoid>

In contrib there's a program, oid2name, which will show the name/number
mappings.