For a view, how does one show what schema was used to qualify a relation,
when the query used to create the view originally left the relation
unqualified?
The qualification of the view query seems static in all uses of the view.
Using pg_get_viewdef() returns the unqualified relation, but Postgres
always executes a qualified version of the view query, seemingly determined
upon creation of the view.
That implies the final qualifier is stored by Postgres, but I don't know
how to show it.
Thanks,
Pete O'Such