Materialized View¶

Defines a materialized view

Properties¶

Property	Type	Required	Description
`schema`	`string`	yes	The schema the materialized view is created in.
`name`	`string`	yes	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.
`security_labels`	security_labels	—	Security Labels.
`dependencies`	dependencies	—	Database objects this object is dependent upon.

Exactly one of these must hold:

No other properties are accepted.