Received: from tangent.ics.olemiss.edu (tangent.ics.olemiss.edu [130.74.31.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e5SIom103770 for ; Wed, 28 Jun 2000 14:50:48 -0400 (EDT) Received: from Betelgeuse.olemiss.edu (host251.ics.olemiss.edu [130.74.31.251]) by tangent.ics.olemiss.edu (8.9.3/8.8.7) with ESMTP id NAA19005 for ; Wed, 28 Jun 2000 13:47:17 -0500 Message-Id: <4.3.2.7.2.20000628135033.01f37368@sunset.backbone.olemiss.edu> X-Sender: tswan@sunset.backbone.olemiss.edu X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 28 Jun 2000 13:50:45 -0500 To: pgsql-sql@hub.org From: Thomas Swan Subject: Finding the names of inheriting classes Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_8460453==_.ALT" X-Archive-Number: 200006/266 --=====================_8460453==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed This is actually two problems... I'm at a loss on how identify or get the names of children of a parent class. For example, I have three children of a parent class Cities : Big_Cities, Little_Cities, Not_Cities. I know that I can do a select * from Cities* and get all rows from Cities and Cities' children. For the first question, is there a way I can get the names of the tables (classes) that inherit from a parent class? For example, getting the names of the tables "Big_Cities","Little_Cities",and "Not_Cities" from a statement asking what are the children of tables (class) Cities. The second question revolves around the select * from Cities*. If Cities has a "name" column and Big_Cities has a "population" column added and I do a select * from Cities* the resulting table only has the "name" column. Is there a way to get a table that has all the columns (not just the ones in common) and put nulls in the columns for which there is no information or data? - - Thomas Swan - ________________________________________ - Graduate Student - Computer Science - The University of Mississippi - - "People can be sorted into two fundamental groups, - those that divide people into two groups and - those that don't." --=====================_8460453==_.ALT Content-Type: text/html; charset="us-ascii"
This is actually two problems...

I'm at a loss on how identify or get the names of children of a parent class.

For example, I have three children of a parent class Cities : Big_Cities, Little_Cities, Not_Cities.   I know that I can do a select * from Cities* and get all rows from Cities and Cities' children.

For the first question, is there a way I can get the names of the tables (classes) that inherit from a parent class?
For example, getting the names of the tables "Big_Cities","Little_Cities",and "Not_Cities" from a statement asking what are the children of tables (class) Cities.

The second question revolves around the select * from Cities*.

If Cities has a "name" column and Big_Cities has a "population" column added and I do a select * from Cities* the resulting table only has the "name" column.  Is there a way to get a table that has all the columns (not just the ones in common) and put nulls in the columns for which there is no information or data?
-
- Thomas Swan
- ________________________________________
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be sorted into two fundamental groups,
- those that divide people into two groups and
- those that don't." --=====================_8460453==_.ALT--