Re: Any work being done on materialized view?

What exactly are the features you are looking for? Materialized views are
treated as tables in PostgreSQL and you can create indexes on them.

https://www.postgresql.org/docs/9.4/static/sql-creatematerializedview.html

"CREATE MATERIALIZED VIEW is *similar to **CREATE TABLE* AS, except that it
also remembers the query used to initialize the view, so that it can be
refreshed later upon demand. *A materialized view has many of the same
properties as a table*, but there is no support for temporary materialized
views or automatic generation of OIDs."

On Sat, Dec 3, 2016 at 8:55 AM, inspector morse <inspectormorse86(at)gmail(dot)com>
wrote:

> Is there any work being done on materialized views for version 9.7? This
> postgresql feature is severely lacking compared to similar features like
> indexed views by sql server.
>
>
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.