Unqualified relations in views

Pete O'Such <posuch@gmail.com>

From: "Pete O'Such" <posuch@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2023-09-13T05:58:28Z
Lists: pgsql-general
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