From: Jost Degenhardt <jostdegenhardt@web.de>
To: pgsql-sql@postgresql.org
Subject: Finding out to which table a specific row belongs
Date: Wed, 14 Dec 2005 18:26:23 +0100
Message-ID: <43A055BF.1030907@web.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jostdegenhardt@web.de
Subject: Re: Finding out to which table a specific row belongs
In-Reply-To: <43A055BF.1030907@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox