Re: Materialized views don't show up in information_schema

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Sehrope Sarkuni <sehrope(at)jackdb(dot)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.

I'm not particularly thrilled with this answer. I'd aruge that the
'materialized' part of mat views isn't relevant to the standard, which
does not concern itself with such performance-oriented considerations,
and therefore, to the standard's view (pun rather intended), they're
views.

Thanks,

Stephen