PostgreSQL Views

In this section, we will introduce you to the PostgreSQL views concept and show you how to manage views such as creating, modifying, and removing views from the database. In addition, we will illustrate how to create updatable views and give you a complete example of materialized views, which is a very powerful feature of PostgreSQL.

• Managing PostgreSQL views – introduces you to the views concept and show you how to create, modify, and remove PostgreSQL views.
• Creating PostgreSQL updatable views – gives you examples of creating updatable views.
• PostgreSQL materialized views  – shows you the concept of materialized views and provide you with the steps of creating and refreshing data for a materialized view.
• Creating updatable views using the WITH CHECK OPTION clause – this tutorial shows you how to use the WITH CHECK OPTION clause to check the view-defining condition when you make a change to the base table through the view. It also discusses the scope of check including LOCAL and CASCADED.
• Creating recursive views – introduces you to the recursive view and shows you an example of creating a recursive view in PostgreSQL.