PostgreSQL
51.75. pg_matviews
The view pg_matviews provides access to useful information about each materialized view in the database.
Table 51.76. pg_matviews Columns
| Name | Type | References | Description |
|---|---|---|---|
|
|
|
Name of schema containing materialized view |
|
|
|
Name of materialized view |
|
|
|
Name of materialized view’s owner |
|
|
|
Name of tablespace containing materialized view (null if default for database) |
|
|
True if materialized view has (or recently had) any indexes |
|
|
|
True if materialized view is currently populated |
|
|
|
Materialized view definition (a reconstructed |
+
| Prev | Up | Next |
|---|---|---|
51.74. |
51.76. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group