Re: Materialized views don't show up in information_schema

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