Materialized View

Defines a materialized view

Properties

Property	Type	Required	Description
schema	string	—	The schema the materialized view is created in.
name	string	—	The materialized view name.
owner	string	—	The role that owns the materialized view.
sql	string	—	User-provided raw SQL snippet.
columns	array of (string | object)	—	An optional list of names to be used for columns of the materialized view. If not given, the column names are deduced from the query.
table_access_method	string	—	Define the table access method.
storage_parameters	object	—	Storage parameter settings for the materialized view. A toast. prefix targets the view's TOAST table instead of the view itself.
tablespace	string	—	Specifies the name of the tablespace in which the materialized view is to be created.
query	string	—	A SELECT or VALUES command which will provide the columns and rows of the materialized view.
indexes	array of index	—	An array of indexes on the materialized view.
comment	string	—	An optional comment about the materialized view.
dependencies	dependencies	—	Database objects this object is dependent upon.

Mutually exclusive forms

Exactly one of these must hold:

• query, without sql
• sql

No other properties are accepted.

---

Source: schemata/materialized_view.yml · Resolved JSON Schema: materialized_view.json