Selecting * from the base table but getting the inheriteds columns

From: "James Adams" <pornstarbatman(at)hotmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Selecting * from the base table but getting the inheriteds columns
Date: 2002-10-29 22:37:46
Message-ID: OE50hCLwHc9ny7BXx4X00000bd3@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I have a "baseTable". I have a number of decendantTables that INHERIT from the base table.

I want to do somthing like

=>select * from baseTable;

But I want it to return the data in the all the descendant tables along with the extra column that they contain. How do I do this?

please help

many thanks for your time

James

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2002-10-30 02:22:00 Re: BOOLEAN question
Previous Message Peter Eisentraut 2002-10-29 22:19:55 Re: BOOLEAN question