Views in PostgreSQL
Learn how to create and execute views and materialized views in PostgreSQL using the pgAdmin GUI tool. Improve performance with materialized views.
At a Glance
In this project, you will learn how to create and execute views and materialized views in the PostgreSQL database service using the pgAdmin graphical user interface (GUI) tool.
In this project, you will learn how to create and execute views and materialized views in the PostgreSQL database service using the pgAdmin graphical user interface (GUI) tool. Materialized views behave differently compared to regular views. In materialized views, result set is materialized or saved for future use. You can’t insert, update, or delete rows like in regular views. Materialized views can improve performance.
×
There are no reviews yet.