Re: Quick Inheritance questions

Adam Witney <awitney@sghms.ac.uk> writes:
> I have a table that inherits an id field from a parent table, is there a way
> of determining which child table the row containing a particular id value
> comes from?

SELECT tableoid, ...other stuff... FROM parenttable WHERE ...

Typically you'd add a join to pg_class so that you can identify the
table by name instead of OID, but that's the basic idea.

> Also, just out of interest, if one table inherits a field from another table
> does the values contained within that field get stored on disk twice? (once
> for the parent table and once for the child table).

No.

            regards, tom lane