PostgreSQL Materialized Views

• https://www.postgresql.org/docs/current/rules-materializedviews.html

• Timescale Continuous Aggregates

Errors

• ERROR: must be owner of materialized view your_view_name (SQLSTATE=42501)

ALTER MATERIALIZED VIEW xxxx.yyyyyy OWNER to YourUser;

Related

• Schema

See also

• Views, materialized view, CREATE VIEW, Materialized Views
• PostgreSQL, VACUUM, Materialized Views, Triggers, Table Partitioning