Views

Regular, materialized, and recursive view declarations.
PageDescription
RegularStandard views; CREATE OR REPLACE on query changes
MaterializedMaterialized views; DROP + recreate on query changes
RecursiveRECURSIVE VIEW with a working table
Regular Views

View declarations; query changes emit CREATE OR REPLACE VIEW; output column list changes emit DROP VIEW CASCADE.

Materialized Views

Materialized views; any query change emits DROP MATERIALIZED VIEW then CREATE MATERIALIZED VIEW.

Recursive Views

RECURSIVE VIEW declarations with a named working table.