Skip to content

Home > extract-pg-schema > MaterializedViewDetails

MaterializedViewDetails interface

Materialized view in a schema.

Signature:

typescript
export interface MaterializedViewDetails extends PgType<"materializedView">

Extends: PgType<"materializedView">

Properties

Property

Modifiers

Type

Description

columns

MaterializedViewColumn[]

Columns in the materialized view.

definition

string

The SQL definition of the view.

fakeInformationSchemaValue

InformationSchemaView

The Postgres information_schema views do not contain info about materialized views. This value is the result of a query that matches the one for regular views. Use with caution, not all fields are guaranteed to be meaningful and/or accurate.