"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
In response to
pgsql-novice by date
|Next:||From: Mija Lee||Date: 2007-08-30 17:15:22|
|Subject: Could not remove file messages|
|Previous:||From: Matthews, James||Date: 2007-08-30 13:30:56|
|Subject: Querying a parent table's child schemas|