Re: Materialized views don't show up in information_schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Materialized views don't show up in information_schema
Date
Msg-id 3794.1412980686@sss.pgh.pa.us
Whole thread Raw
In response to Materialized views don't show up in information_schema  (Sehrope Sarkuni <sehrope@jackdb.com>)
Responses Re: Materialized views don't show up in information_schema
List pgsql-hackers
Sehrope Sarkuni <sehrope@jackdb.com> writes:
> I've been testing out some of the new materialized view functionality
> in 9.4 and noticed that they don't show up in the information_schema
> data dictionary views, specifically information_schema.tables or
> information_schema.views (sample output is below and it's the same for
> 9.3 as well).

> Is this on purpose or just an oversight?

It's on purpose.  The information_schema can only show objects that
exist in the SQL standard.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Sehrope Sarkuni
Date:
Subject: Materialized views don't show up in information_schema
Next
From: Stephen Frost
Date:
Subject: Re: Materialized views don't show up in information_schema