select view definition from pg_views feature request

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема select view definition from pg_views feature request
Дата
Msg-id CAGCvxebwiB+b5y_jAj_TLX+S6CoNbVFkmPqc9wTU5FLeNUa5jQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: select view definition from pg_views feature request
Список 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)?

В списке pgsql-general по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: 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)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: select view definition from pg_views feature request