Received: from www2.gmx.net (qmailr@www2.gmx.net [195.63.104.42]) by hub.org (8.9.1/8.9.1) with SMTP id JAA13008 for ; Mon, 7 Dec 1998 09:36:57 -0500 (EST) (envelope-from joerg.troester@gmx.net) From: joerg.troester@gmx.net Received: (qmail 7613 invoked by uid 65534); 7 Dec 1998 14:36:42 -0000 Date: Mon, 7 Dec 1998 15:36:42 +0100 (MET) To: pgsql-sql@postgresql.org Subject: Inheritance and origin of rows X-Authenticated-Sender: joerg.troester@gmx.net X-Authenticated-IP: [194.45.74.211] Message-Id: <7604.913041402@www.gmx.net> X-Mailer: WWW-Mail 0.97a/b (Global Message Exchange) In my database I created a table "partners" and two tables "individuals" and "companies" which are inherited from "partners". Table "partners" has columns "name", "address", "phone",... Now I want to query any partner being an individual or company by a statement like "select name,address,phone from partners*". For further proceeding the information is needed which table (individuals or companies) any row is taken from. My question is: * is there any possibility to retrieve this information from a system table (e.g. the name of the table where a row/rowid resides in) * or do I need a workaround like adding a column "tablename" into table "partners"? Thanks a lot for answering. --- Sent through Global Message Exchange - http://www.gmx.net