目录

pg_matviews

列出可用物化视图的系统视图

pg_matviews 是一个 系统目录 视图，列出可用的物化视图。

pg_matviews 在 PostgreSQL 9.3 中添加。

按 PostgreSQL 版本定义

pg_matviews (PostgreSQL 19)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 18)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 17)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 16)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 15)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 14)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 13)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 12)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 11)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 10)

              View "pg_catalog.pg_matviews"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 schemaname   | name    |           |          | 
 matviewname  | name    |           |          | 
 matviewowner | name    |           |          | 
 tablespace   | name    |           |          | 
 hasindexes   | boolean |           |          | 
 ispopulated  | boolean |           |          | 
 definition   | text    |           |          |

文档: pg_matviews

pg_matviews (PostgreSQL 9.6)

   View "pg_catalog.pg_matviews"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 schemaname   | name    | 
 matviewname  | name    | 
 matviewowner | name    | 
 tablespace   | name    | 
 hasindexes   | boolean | 
 ispopulated  | boolean | 
 definition   | text    |

文档: pg_matviews

pg_matviews (PostgreSQL 9.5)

   View "pg_catalog.pg_matviews"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 schemaname   | name    | 
 matviewname  | name    | 
 matviewowner | name    | 
 tablespace   | name    | 
 hasindexes   | boolean | 
 ispopulated  | boolean | 
 definition   | text    |

文档: pg_matviews

pg_matviews (PostgreSQL 9.4)

   View "pg_catalog.pg_matviews"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 schemaname   | name    | 
 matviewname  | name    | 
 matviewowner | name    | 
 tablespace   | name    | 
 hasindexes   | boolean | 
 ispopulated  | boolean | 
 definition   | text    |

文档: pg_matviews

pg_matviews (PostgreSQL 9.3)

   View "pg_catalog.pg_matviews"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 schemaname   | name    | 
 matviewname  | name    | 
 matviewowner | name    | 
 tablespace   | name    | 
 hasindexes   | boolean | 
 ispopulated  | boolean | 
 definition   | text    |

文档: pg_matviews

变更历史

自 PostgreSQL 9.3 添加以来，此视图未发生更改。

示例

postgres=# CREATE TABLE foo (id int);
CREATE TABLE

postgres=# CREATE MATERIALIZED VIEW bar AS SELECT * FROM foo;
SELECT 0

postgres=# SELECT * FROM pg_matviews ;
 schemaname | matviewname | matviewowner | tablespace | hasindexes | ispopulated |   definition   
------------+-------------+--------------+------------+------------+-------------+----------------
 public     | bar         | postgres     |            | f          | t           |  SELECT foo.id+
            |             |              |            |            |             |    FROM foo;
(1 row)

分类

DDL, 系统目录

另请参阅

CREATE MATERIALIZED VIEW, ALTER MATERIALIZED VIEW, DROP MATERIALIZED VIEW

反馈

请在此处 提交关于 "pg_matviews" 的任何评论、建议或更正。