Re: Querying a parent table's child schemas - Mailing list pgsql-novice

From Tom Lane
Subject Re: Querying a parent table's child schemas
Date
Msg-id 1982.1188489674@sss.pgh.pa.us
Whole thread Raw
In response to Querying a parent table's child schemas  ("Matthews, James" <jmatthews@Railpower.com>)
Responses Re: Querying a parent table's child schemas
List pgsql-novice
"Matthews, James" <jmatthews@Railpower.com> writes:
>       I was wondering if there was a way to SELECT from a parent table
> and display the schema associated with a child table's data.

It's not entirely clear to me which meaning of "schema" you have in
mind, but perhaps the tableoid system column would help you?  That
lets you determine which child table the row really came from,
and then you can join to the system catalogs to get whatever data
you are actually after.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Matthews, James"
Date:
Subject: Querying a parent table's child schemas
Next
From: Mija Lee
Date:
Subject: Could not remove file messages