select view definition from pg_views feature request

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: select view definition from pg_views feature request
Date: 2019-11-03 20:33:55
Message-ID: CAGCvxebwiB+b5y_jAj_TLX+S6CoNbVFkmPqc9wTU5FLeNUa5jQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
that)?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-11-03 21:15:23 Re: select view definition from pg_views feature request
Previous Message Francisco Olarte 2019-11-03 08:49:12 Re: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)