Can I set search_path='' (ie to a string that does not match any existing
schema)? Would that be the proper way to guarantee that the definition for
any view will always be fully-qualified?
On Sun, Nov 3, 2019 at 3:15 PM Tom Lane wrote:
> Michael Shapiro writes:
> >
Is that how PgAdmin does it? The views extracted by PgAdmin are fully
qualified
On Sun, Nov 3, 2019 at 3:15 PM Tom Lane wrote:
> Michael Shapiro writes:
> > It seems that the definition of a view from pg_catalog.pg_views does not
> > qualify the tables used in the view if
It seems that the definition of a view from pg_catalog.pg_views does not
qualify the tables used in the view if the tables are in the current search
path.
Is it possible to either have the definition always qualify all tables
independent of the search_path (or else provide a new column that does
t
