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