Materialized PostgreSQL Views

Question

I have completed a course on Oracle databases and have since played with it. One of my friends told me that PostgreSQL is a very good database management system that has object-oriented features.

In an Oracle database, this is a simple and easy process for creating materialized views. BUT, despite the fact that I heard that PostgreSQL supports materialized representations in a few people, I can’t figure out how to do this.

Please inform.

Answer 1

For PostgreSQL version 9.2 and below, read the following article on how to create materialized views using functions and triggers.

• http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views

---

Since version 9.3 , materialized views are supported based on:

For more information on this topic, please refer to the following PostgreSQL documentation articles:

• http://www.postgresql.org/docs/devel/static/sql-creatematerializedview.html
• http://www.postgresql.org/docs/devel/static/rules-materializedviews.html

Answer 2

There is no native support for materialized views in postgres.

You can try to simulate them using triggers / stored procedures as described in this article .