Relation from database to filename of e.g. table

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: pgsql-admin(at)postgresql(dot)org
Subject: Relation from database to filename of e.g. table
Date: 2003-10-26 16:46:31
Message-ID: 3f9bf9b0_2@news.bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Admins

Can someone please tell me, which relation gives me the link between a
database and a table?

I want to find out, which table belongs to which database in a cluster.

Something like

SELECT d.datname, c.relname
FROM pg_database d, pg_class c, pg_xxx x
WHERE d.oid = x.oid
AND x.oid = c.relfilenode

But I did not find the pg_xxx.

Thanks
Oli

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2003-10-26 23:30:39 Re: Performance failure / automatic restart / cron ?
Previous Message athbelahcene khelifa 2003-10-26 13:09:58 unsubscribe