Re: don't see materialized views in information_schema - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: don't see materialized views in information_schema
Date
Msg-id CAFj8pRAHgEqrf5BcsdkJ4U8-49j6HbnYmRzuM3PAk=N7VS7-qQ@mail.gmail.com
Whole thread Raw
In response to Re: don't see materialized views in information_schema  (Erik Rijkers <er@xs4all.nl>)
Responses Re: don't see materialized views in information_schema
List 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 by date:

Previous
From: Erik Rijkers
Date:
Subject: Re: don't see materialized views in information_schema
Next
From: Richard Guo
Date:
Subject: Re: Pulling up direct-correlated ANY_SUBLINK