Views and Materialized Views
Learn Views and Materialized Views (Design and Database Objects, PostgreSQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
A view is a saved query that looks like a table. A materialized view also stores the result, so it is fast but must be refreshed.