{"Entry":{"collection":"catalog","key":"pg_matviews","name":"pg_matviews","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.2","order":false,"removed":[],"status":"added","to":"9.3","types":[]}],"column_count":7,"content_hash":"8dc013ed8b2929a4a1c23938cc66d9d541c7f18a4b9f7c759b1bb370ea692098","derived_content_hash":"2ab83fc5d8742b8f02d976406d5977980bf559077515bea399d70f680227a87e","first_version":"9.3","imported_at":"2026-09-30T00:40:55.62467+08:00","kind":"view","last_version":"20","name":"pg_matviews","position":45,"present_in":["9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:feec4a3724eef2f28a402a9d2918f61b8b9c23c495ffce0cac1f1673d96c3808","summary":"The view pg_matviews provides access to useful information about each materialized view in the database.","summary_zh":"视图 pg_matviews 提供了对数据库中每个物化视图的有用信息的访问。"}},"Definition":{"Collection":"catalog","Key":"pg_matviews","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_matviews","SourceRevision":"catalog-bilingual-repair:feec4a3724eef2f28a402a9d2918f61b8b9c23c495ffce0cac1f1673d96c3808","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing materialized view","description_zh":"包含物化视图的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of materialized view","description_zh":"物化视图名称","documented":true,"documented_name":"matviewname","hidden":false,"name":"matviewname","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of materialized view's owner","description_zh":"物化视图拥有者名称","documented":true,"documented_name":"matviewowner","hidden":false,"name":"matviewowner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of tablespace containing materialized view (null if default for database)","description_zh":"包含物化视图的表空间名（如使用数据库默认表空间则为 NULL）","documented":true,"documented_name":"tablespace","hidden":false,"name":"tablespace","not_null":false,"references":"pg_tablespace.spcname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"True if materialized view has (or recently had) any indexes","description_zh":"如果物化视图有（或者最近有过）任何索引，则此列为真","documented":true,"documented_name":"hasindexes","hidden":false,"name":"hasindexes","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if materialized view is currently populated","description_zh":"如果物化视图当前已被填充，则此列为真","documented":true,"documented_name":"ispopulated","hidden":false,"name":"ispopulated","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Materialized view definition (a reconstructed SELECT query)","description_zh":"物化视图的定义（一个重建的 SELECT 查询）","documented":true,"documented_name":"definition","hidden":false,"name":"definition","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_matviews provides access to useful information about each materialized view in the database.","description_zh":"视图 pg_matviews 提供了对数据库中每个物化视图的有用信息的访问。","description_zh_html":"\u003cp\u003e视图 pg_matviews 提供了对数据库中每个物化视图的有用信息的访问。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.18.5","file":"view-pg-matviews.html","lang":"en","sha256":"1d99d211debeaba8fcb5cff1b1854f94364c5fe2319315ed415f1afd8dc68ea7","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","matviewname","matviewowner","tablespace","hasindexes","ispopulated","definition"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-matviews.html","sha256":"ace12eeae849fc63cfe160e49eb6f66da04fb091ab025caedba9e8f3fc890309","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:2d999315155f22ac16fb17ff37eb297a713180302db635c736a6470f4fe7234a","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.18.5","file":"view-pg-matviews.html","lang":"en","sha256":"1d99d211debeaba8fcb5cff1b1854f94364c5fe2319315ed415f1afd8dc68ea7","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-matviews.html","sha256":"ace12eeae849fc63cfe160e49eb6f66da04fb091ab025caedba9e8f3fc890309","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:2d999315155f22ac16fb17ff37eb297a713180302db635c736a6470f4fe7234a","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","matviewname","matviewowner","tablespace","hasindexes","ispopulated","definition"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_matviews","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_matviews","Summary":"The view pg_matviews provides access to useful information about each materialized view in the database.","BodyHTML":"\u003cp\u003eThe view pg_matviews provides access to useful information about each materialized view in the database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:feec4a3724eef2f28a402a9d2918f61b8b9c23c495ffce0cac1f1673d96c3808","ContentHash":"6e09442c126fb2600ac87a0b434f152246460ade1dcb7d7a879a5b7490911ef0","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing materialized view","description_zh":"包含物化视图的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of materialized view","description_zh":"物化视图名称","documented":true,"documented_name":"matviewname","hidden":false,"name":"matviewname","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of materialized view's owner","description_zh":"物化视图拥有者名称","documented":true,"documented_name":"matviewowner","hidden":false,"name":"matviewowner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of tablespace containing materialized view (null if default for database)","description_zh":"包含物化视图的表空间名（如使用数据库默认表空间则为 NULL）","documented":true,"documented_name":"tablespace","hidden":false,"name":"tablespace","not_null":false,"references":"pg_tablespace.spcname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"True if materialized view has (or recently had) any indexes","description_zh":"如果物化视图有（或者最近有过）任何索引，则此列为真","documented":true,"documented_name":"hasindexes","hidden":false,"name":"hasindexes","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if materialized view is currently populated","description_zh":"如果物化视图当前已被填充，则此列为真","documented":true,"documented_name":"ispopulated","hidden":false,"name":"ispopulated","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Materialized view definition (a reconstructed SELECT query)","description_zh":"物化视图的定义（一个重建的 SELECT 查询）","documented":true,"documented_name":"definition","hidden":false,"name":"definition","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_matviews provides access to useful information about each materialized view in the database."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}