X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 612A59DC830 for ; Wed, 14 Dec 2005 13:26:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32310-02 for ; Wed, 14 Dec 2005 13:26:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 4CCE29DC82E for ; Wed, 14 Dec 2005 13:26:37 -0400 (AST) Received: from smtp07.web.de (smtp07.web.de [217.72.192.225]) by svr2.postgresql.org (Postfix) with ESMTP id F2048F0B1D for ; Wed, 14 Dec 2005 17:26:36 +0000 (GMT) Received: from [134.102.71.157] (helo=[127.0.0.1]) by smtp07.web.de with asmtp (WEB.DE 4.105 #340) id 1EmaOf-00023O-00 for pgsql-sql@postgresql.org; Wed, 14 Dec 2005 18:26:33 +0100 Message-ID: <43A055BF.1030907@web.de> Date: Wed, 14 Dec 2005 18:26:23 +0100 From: Jost Degenhardt User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Finding out to which table a specific row belongs Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Sender: jostdegenhardt@web.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/119 X-Sequence-Number: 23661 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