CREATE VIEW

CREATE VIEW view_name AS query;

select * from view_name;

CREATE OR REPLACE view_name as query;

CREATE MATERIALIZED VIEW view_name AS query WITH [NO] DATA;

REFRESH MATERIALIZED VIEW view_name;

• WITH DATA - загрузить данные сразу

• WITH NO DATA - позже