Re: Determining Inheritance - Mailing list pgsql-sql

From Tom Lane
Subject Re: Determining Inheritance
Date
Msg-id 28943.1065018394@sss.pgh.pa.us
Whole thread Raw
In response to Determining Inheritance  ("Gordon Ross" <G.Ross@ccw.gov.uk>)
List pgsql-sql
"Gordon Ross" <G.Ross@ccw.gov.uk> 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


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Creating Index
Next
From: OpenGis
Date:
Subject: Link Oracle tables in Postgre