Re: Querying a parent table's child schemas

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Matthews, James" <jmatthews(at)Railpower(dot)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