PostgreSQL - Views and Materialized Views
Given the table
What will be the result of
orders(order_id INT, amount INT) with data:order_id | amount ---------+-------- 1 | 100 2 | 200 3 | 300and the materialized view:
CREATE MATERIALIZED VIEW mv_total AS SELECT SUM(amount) AS total_amount FROM orders;
What will be the result of
SELECT * FROM mv_total; immediately after creation?