PostgreSQL, views vs stored procedures
In this short Postgres tutorial you鈥檒l learn the differences between choosing a view or stored procedure to save a SELECT query in PostgreSQL. ...
PostgreSQL
The difference between regular views and materialized views in PostgreSQL
Materialized views in PostgreSQL differ from the regular ones as they do physically store the data in the database. ...
How to create a VIEW in PostgreSQL
In PostgreSQL, view is a virtual table. It represents the result of a SELECT query and can be used to quickly get access to data without having to execute the full query. ...
How to save a SELECT query in PostgreSQL
Learn how you can use stored procedures to give a name to any of your SELECT queries and make them reusable. ...