Task: Implement Auto-Refreshing Materialized View in PostgreSQL

Task: Implement Auto-Refreshing Materialized View in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Create a PostgreSQL setup that ensures a materialized view is always up to date by using triggers and functions to automatically refresh the materialized view whenever the underlying…

The task

Create a PostgreSQL setup that ensures a materialized view is always up to date by using triggers and functions to automatically refresh the materialized view whenever the underlying tables are modified (INSERT, UPDATE, DELETE).

Part of PrimeIntellect/Terminal-Lego-15k.