Create View in PostgreSQL
Read here: https://www.concretepage.com/database...
SQL View is a view of a query. It is not saved in database anywhere rather query is run every time when that view is referenced in a query. We can think SQL views as virtual tables that results are populated from a simple or complex query.