PostgreSQL materialized views

Question

I finished my course on Oracle databases and have been playing with it since sometime. One of my friends told me that PostgreSQL is a very good database management system which has object oriented capabilities.

On an Oracle database, it is a straightforward and easy process to create materialized views. BUT despite of having heard that PostgreSQL supports materialized views from few people, I am unable to figure out how to do that.

Please advise.

Obvious question: why do you want materialised views? Why would you need them? — wildplasser
– wildplasser, Commented Feb 25, 2012 at 14:20

Beryllium · Accepted Answer · 2013-09-15 10:05:04Z

14

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

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

Since version 9.3, materialized views are natively supported:

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

edited Sep 15, 2013 at 10:05

Beryllium

13k11 gold badges59 silver badges88 bronze badges

answered Feb 25, 2012 at 13:57

Nick Binnet

2,0208 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

T.R. Over a year ago

+1 for updating your answer to account for the new feature. Wish more people did this.

soulcheck · Accepted Answer · 2012-02-25 13:57:14Z

3

There's no native support for materialized views in postgres.

You could try to emulate them with triggers/stored procedures as described in this article.

answered Feb 25, 2012 at 13:57

soulcheck

36.9k6 gold badges95 silver badges91 bronze badges

Collectives™ on Stack Overflow

PostgreSQL materialized views

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related