"Gordon Ross" <[EMAIL PROTECTED]> writes:
> Is there any way to determine which table a row belows to, if I do a
> search on the top level table:
Look at the built-in column "tableoid". You can join this to
pg_class.oid to retrieve the table name.
regards, tom lane
-
Is there any way to determine which table a row belows to, if I do a
search on the top level table:
e.g. I have a table called "BASE". There are two tables which inherit
from "BASE" called "SUBTABLE1" and "SUBTABLE2"
If I do a SELECT * FROM BASE WHERE blah; how can I tell which table
(either SUBT