Request a Demo
Home   >   mailing lists

select view definition from pg_views feature request - Mailing list pgsql-general

From Michael Shapiro
Subject select view definition from pg_views feature request
Date
Msg-id CAGCvxebwiB+b5y_jAj_TLX+S6CoNbVFkmPqc9wTU5FLeNUa5jQ@mail.gmail.com
Whole thread Raw
Responses Re: select view definition from pg_views feature request
List pgsql-general
Tree view
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)?

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Getting following error in using cursor to fetch the records froma large table in c language(current transaction is aborted, commands ignoreduntil end of transaction block)
Next
From: Tom Lane
Date:
Subject: Re: select view definition from pg_views feature request