Master PostgreSQL Views: 5 Essential Types to Optimize Your Database

A PostgreSQL view is essentially a saved (named) query that you can use like a new table

[{"selector":"#anim-8a43b52c-19f2-4db0-9f34-86f7c3069744 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

It doesn’t store data on its own but instead just displays the newest, most current result each time it is queried

[{"selector":"#anim-510005f4-ff5e-4ef6-84ae-f969c1e9c8b5 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

A materialized view is a special type of view in PostgreSQL that stores the result of the query physically, just like a table

[{"selector":"#anim-10126661-7333-4b7e-99c1-c8cbb3add018 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

PostgreSQL Views simplify complex queries through the encapsulation of duplicate SQL logic

[{"selector":"#anim-617ab1a8-d2e4-42a6-87fa-f03f3e5b4d24 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

Materialized views are not updated by default when the base tables are changed. You have to manually refresh them using the REFRESH MATERIALIZED VIEW command

[{"selector":"#anim-f9589b6e-97e0-4881-8d50-2400698c2c50 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

Click here for more details about PostgreSQL Views

[{"selector":"#anim-6a303e71-3ffe-4003-9600-59d9a47f6d36 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0, -8.928571179351586%, 0) translate(0%, -25%) scale(1.5)","translate3d(0, 0%, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]