加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

GS_MATVIEWS.md 12.04 KB

# GS\_MATVIEWS<a name="ZH-CN_TOPIC_0000001086622520"></a>

GS\_MATVIEWS视图提供了关于数据库中每一个物化视图的信息。

**表 1**  GS\_MATVIEWS字段

<a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_tef4747cefaab47fe89062c4899b9dd81"></a>
<table><thead align="left"><tr id="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_r7bbada6239ec422cb76d6886a6528dbf"><th class="cellrowborder" valign="top" width="18.87%" id="mcps1.2.5.1.1"><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a14c20134f2fa468bba56c9b8e5306278"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a14c20134f2fa468bba56c9b8e5306278"></a>名称
</th>
<th class="cellrowborder" valign="top" width="9.84%" id="mcps1.2.5.1.2"><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a5116e0331a5a4c22938b4d1c40bba627"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a5116e0331a5a4c22938b4d1c40bba627"></a>类型
</th>
<th class="cellrowborder" valign="top" width="30.659999999999997%" id="mcps1.2.5.1.3"><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a4ba93939c3c3459d9e5ed3d3bb577a42"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a4ba93939c3c3459d9e5ed3d3bb577a42"></a>引用
</th>
<th class="cellrowborder" valign="top" width="40.63%" id="mcps1.2.5.1.4"><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_af663d904f75649d48d712ae335e3edfe"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_af663d904f75649d48d712ae335e3edfe"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_rf7c766cddff0407bb805393c013b902a"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a381342a7ee6a4ba5be52969e933df8d2"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a381342a7ee6a4ba5be52969e933df8d2"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a800aa141d95241c2bffae422411df91a"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a800aa141d95241c2bffae422411df91a"></a>name
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a0d2b071600aa476894069659495ce641"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a0d2b071600aa476894069659495ce641"></a><a href="PG_NAMESPACE.md">PG_NAMESPACE</a>.nspname
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a0f0b904e963347098535b30a55046954"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a0f0b904e963347098535b30a55046954"></a>物化视图的模式名。
</td>
</tr>
<tr id="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_raabc99bc831f4e3da2c3078018ec184d"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a15610165a00747398a8d9ce49d307faa"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a15610165a00747398a8d9ce49d307faa"></a>matviewname
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aa78ed822b23d4e23b34a8becf42693e7"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aa78ed822b23d4e23b34a8becf42693e7"></a>name
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aa4bd6b80055b4818825bea7fa2ed45fe"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aa4bd6b80055b4818825bea7fa2ed45fe"></a><a href="PG_CLASS.md">PG_CLASS</a>.relname
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_ae896aeff85fd4377b4113e7a94a2ec71"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_ae896aeff85fd4377b4113e7a94a2ec71"></a>物化视图名。
</td>
</tr>
<tr id="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_r721bd262314643b7afead249a9c84b36"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a2f198a715e4d45d99a8356c7b47b46fd"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a2f198a715e4d45d99a8356c7b47b46fd"></a>matviewowner
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_acbcef8e6652a4744b3cc4cb08b8346a2"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_acbcef8e6652a4744b3cc4cb08b8346a2"></a>name
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aadc07cb07d734a809af4d110a07c6104"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_aadc07cb07d734a809af4d110a07c6104"></a><a href="PG_AUTHID.md">PG_AUTHID</a>.Erolname
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a8eebe34c82274f0aafcc2eedea6eb267"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a8eebe34c82274f0aafcc2eedea6eb267"></a>物化视图的所有者。
</td>
</tr>
<tr id="zh-cn_topic_0283136548_row1967927115416"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_p19967162795414"></a><a name="zh-cn_topic_0283136548_p19967162795414"></a>tablespace
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_p11967142714541"></a><a name="zh-cn_topic_0283136548_p11967142714541"></a>name
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_p09671627195415"></a><a name="zh-cn_topic_0283136548_p09671627195415"></a><a href="PG_TABLESPACE.md">PG_TABLESPACE</a>.spcname
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_p59679278541"></a><a name="zh-cn_topic_0283136548_p59679278541"></a>物化视图的表空间名（如果使用数据库默认表空间则为空）
</td>
</tr>
<tr id="zh-cn_topic_0283136548_row20541132712558"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_p554292795514"></a><a name="zh-cn_topic_0283136548_p554292795514"></a>hasindexes
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_p45421327145519"></a><a name="zh-cn_topic_0283136548_p45421327145519"></a>boolean
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_p7542172715555"></a><a name="zh-cn_topic_0283136548_p7542172715555"></a>-
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_p3542527165520"></a><a name="zh-cn_topic_0283136548_p3542527165520"></a>如果物化视图有（或者最近有过）任何索引，则此列为真。
</td>
</tr>
<tr id="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_r1f2b7df612754c9d8e88267b524c3a40"><td class="cellrowborder" valign="top" width="18.87%" headers="mcps1.2.5.1.1 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a31db6c504cbc41f4a170ef25b5282a54"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a31db6c504cbc41f4a170ef25b5282a54"></a>definition
</td>
<td class="cellrowborder" valign="top" width="9.84%" headers="mcps1.2.5.1.2 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_af714117bc9e440918302783fbe09bb44"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_af714117bc9e440918302783fbe09bb44"></a>text
</td>
<td class="cellrowborder" valign="top" width="30.659999999999997%" headers="mcps1.2.5.1.3 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_ae7e69388548447bc99cf83fa4d8ac2dd"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_ae7e69388548447bc99cf83fa4d8ac2dd"></a>-
</td>
<td class="cellrowborder" valign="top" width="40.63%" headers="mcps1.2.5.1.4 "><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a54f43de71be1479ebba316242658c99e"></a><a name="zh-cn_topic_0283136548_zh-cn_topic_0237122474_zh-cn_topic_0059778302_a54f43de71be1479ebba316242658c99e"></a>物化视图的定义（一个重构的SELECT查询）。
</td>
</tr>
</tbody>
</table>

一键复制编辑原始数据按行查看历史

提交于 2021-03-20 16:54 . add new feature

GS_MATVIEWS

GS_MATVIEWS视图提供了关于数据库中每一个物化视图的信息。

表 1 GS_MATVIEWS字段

名称	类型	引用	描述
schemaname	name	PG_NAMESPACE.nspname	物化视图的模式名。
matviewname	name	PG_CLASS.relname	物化视图名。
matviewowner	name	PG_AUTHID.Erolname	物化视图的所有者。
tablespace	name	PG_TABLESPACE.spcname	物化视图的表空间名（如果使用数据库默认表空间则为空）
hasindexes	boolean	-	如果物化视图有（或者最近有过）任何索引，则此列为真。
definition	text	-	物化视图的定义（一个重构的SELECT查询）。

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

2.0.0

openGauss / docs

GS_MATVIEWS

简介

发行版

贡献者

近期动态

openGauss / docs .gitee-modal { width: 500px !important; }

GS_MATVIEWS

简介

发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

贡献者

近期动态

搜索帮助

openGauss / docs