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