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. ...

November 17, 2020 路 1 min 路 Coderslang Master

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. ...

November 16, 2020 路 1 min 路 Coderslang Master

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. ...

November 13, 2020 路 2 min 路 Coderslang Master

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. ...

November 8, 2020 路 4 min 路 Coderslang Master