Views in PostgreSQL can be categorized into one of the following categories on the basis of their usage:
- Temporary views: A temporary view is dropped automatically at the end of a user session. If the TEMPORARY or TEMP keywords are not used, then the life cycle of the view starts with the view creation and ends with the action of dropping it.
- Recursive views: A recursive view is similar to recursive functions in high-level languages. The view column list should be specified in recursive views. Recursion in relational databases, such as in recursive views or recursive common table expressions (CTEs), can be used to write very complex queries, specifically for hierarchical data.
- Updatable views: Updatable views allow the user to see the view as a table. This means that the developer can perform INSERT, UPDATE and DELETE on views similar to tables. Updatable views...
