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."
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@xxxxxxxxx> 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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
