Finding out to which table a specific row belongs

From: Jost Degenhardt <jostdegenhardt(at)web(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Finding out to which table a specific row belongs
Date: 2005-12-14 17:26:23
Message-ID: 43A055BF.1030907@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there,
I have the following problem: My database consists of several tables
that are inherited from each other with one single supertable on top of
that hierarchy. Now I would like to select a single row in that
supertable and want to find out to which of the tables in the hierarchy
it belongs. As far as I understand the pg_depend table only shows the
hierarchy of the tables but does not contain the oids of the actual
rows. Is there any possibility to solve this problem by using the pg_*
tables?
I would very much appreciate any help!
Thank you in advance, Jost

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-12-14 17:53:07 Re: Finding out to which table a specific row belongs
Previous Message Gianluca Riccardi 2005-12-14 15:08:05 Re: DB design and foreign keys