Postgres Pro
Downloads
Home   >   mailing lists

Selecting * from the base table but getting the inheriteds columns - Mailing list pgsql-sql

From James Adams
Subject Selecting * from the base table but getting the inheriteds columns
Date
Msg-id OE50hCLwHc9ny7BXx4X00000bd3@hotmail.com
Whole thread Raw
List pgsql-sql
Tree view
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
 
 

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BOOLEAN question
Next
From: Bruno Wolff III
Date:
Subject: Re: BOOLEAN question