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