Postgres Pro
Downloads
Home   >   mailing lists

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

From Erik Rijkers
Subject Re: don't see materialized views in information_schema
Date
Msg-id 654994b9c5163d1e10d6ae37c9726253@xs4all.nl
Whole thread Raw
In response to don't see materialized views in information_schema  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: don't see materialized views in information_schema
List pgsql-hackers
Tree view 
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. )

pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Pulling up direct-correlated ANY_SUBLINK
Next
From: Pavel Stehule
Date:
Subject: Re: don't see materialized views in information_schema