Re: don't see materialized views in information_schema

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Subject: Re: don't see materialized views in information_schema
Date: 2019-09-11 08:02:21
Message-ID: CAFj8pRAHgEqrf5BcsdkJ4U8-49j6HbnYmRzuM3PAk=N7VS7-qQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

st 11. 9. 2019 v 9:49 odesílatel Erik Rijkers <er(at)xs4all(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2019-09-11 08:32:33 Re: Pulling up direct-correlated ANY_SUBLINK
Previous Message Erik Rijkers 2019-09-11 07:49:11 Re: don't see materialized views in information_schema