Re: don't see materialized views in information_schema

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: don't see materialized views in information_schema
Дата
Msg-id CAFj8pRAHgEqrf5BcsdkJ4U8-49j6HbnYmRzuM3PAk=N7VS7-qQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: don't see materialized views in information_schema  (Erik Rijkers <er@xs4all.nl>)
Ответы Re: don't see materialized views in information_schema  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
Список pgsql-hackers


st 11. 9. 2019 v 9:49 odesílatel Erik Rijkers <er@xs4all.nl> napsal:
On 2019-09-11 08:14, Pavel Stehule wrote:
> Hi
>
> [matviews not showing up in information_schema.tables]
>
> Is it expected behave? Tested on master branch.

I think it is; it has been like this all along.

( matviews are in pg_matviews. )

Minimally I miss a entry in information_schema.views

To today I expected so any object should be listed somewhere in information_schema.

Pavel

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

Предыдущее
От: Erik Rijkers
Дата:
Сообщение: Re: don't see materialized views in information_schema
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Pulling up direct-correlated ANY_SUBLINK