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

From Stephen Frost
Subject Re: Materialized views don't show up in information_schema
Date
Msg-id 20141018000318.GY28859@tamriel.snowman.net
Whole thread Raw
In response to Re: Materialized views don't show up in information_schema  (Nicolas Barbier <nicolas.barbier@gmail.com>)
List pgsql-hackers
* Nicolas Barbier (nicolas.barbier@gmail.com) wrote:
> 2014-10-16 Stephen Frost <sfrost@snowman.net>:
>
> > Alright, coming back to this, I have to ask- how are matviews different
> > from views from the SQL standard's perspective?
>
> Matviews that are always up to date when you access them are
> semantically exactly the same as normal views. Matviews that can get
> out of date, however, are not.

And when we have matviews which can be kept up to date..?
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Optimizer on sort aggregate
Next
From: Stephen Frost
Date:
Subject: Re: Materialized views don't show up in information_schema