CODEWITHSUNDEEP
oracle-databasepostgresql
user1232564
user1232564

Reputation: 138

PostgreSQL materialized views

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.

Upvotes: 6

Views: 2923

Answers (2)

Nick Binnet
Nick Binnet

Reputation: 2000

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

Since version 9.3, materialized views are natively supported:

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

Upvotes: 14

soulcheck
soulcheck

Reputation: 36777

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.

Upvotes: 3

Related Questions