Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit5141603

Browse files
committed
Add docs for pg_matviews, which were missed in the initial MV commit.
1 parentcfa3df3 commit5141603

File tree

1 file changed

+84
-1
lines changed

1 file changed

+84
-1
lines changed

‎doc/src/sgml/catalogs.sgml

Lines changed: 84 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6956,6 +6956,11 @@
69566956
<entry>currently held locks</entry>
69576957
</row>
69586958

6959+
<row>
6960+
<entry><link linkend="view-pg-matviews"><structname>pg_matviews</structname></link></entry>
6961+
<entry>materialized views</entry>
6962+
</row>
6963+
69596964
<row>
69606965
<entry><link linkend="view-pg-prepared-statements"><structname>pg_prepared_statements</structname></link></entry>
69616966
<entry>prepared statements</entry>
@@ -7715,6 +7720,83 @@
77157720

77167721
</sect1>
77177722

7723+
<sect1 id="view-pg-matviews">
7724+
<title><structname>pg_matviews</structname></title>
7725+
7726+
<indexterm zone="view-pg-matviews">
7727+
<primary>pg_matviews</primary>
7728+
</indexterm>
7729+
7730+
<indexterm zone="view-pg-matviews">
7731+
<primary>materialized views</primary>
7732+
</indexterm>
7733+
7734+
<para>
7735+
The view <structname>pg_matviews</structname> provides access to
7736+
useful information about each materialized view in the database.
7737+
</para>
7738+
7739+
<table>
7740+
<title><structname>pg_matviews</> Columns</title>
7741+
7742+
<tgroup cols="4">
7743+
<thead>
7744+
<row>
7745+
<entry>Name</entry>
7746+
<entry>Type</entry>
7747+
<entry>References</entry>
7748+
<entry>Description</entry>
7749+
</row>
7750+
</thead>
7751+
<tbody>
7752+
<row>
7753+
<entry><structfield>schemaname</structfield></entry>
7754+
<entry><type>name</type></entry>
7755+
<entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.nspname</literal></entry>
7756+
<entry>Name of schema containing materialized view</entry>
7757+
</row>
7758+
<row>
7759+
<entry><structfield>matviewname</structfield></entry>
7760+
<entry><type>name</type></entry>
7761+
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.relname</literal></entry>
7762+
<entry>Name of materialized view</entry>
7763+
</row>
7764+
<row>
7765+
<entry><structfield>matviewowner</structfield></entry>
7766+
<entry><type>name</type></entry>
7767+
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.rolname</literal></entry>
7768+
<entry>Name of materialized view's owner</entry>
7769+
</row>
7770+
<row>
7771+
<entry><structfield>tablespace</structfield></entry>
7772+
<entry><type>name</type></entry>
7773+
<entry><literal><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>.spcname</literal></entry>
7774+
<entry>Name of tablespace containing materialized view (null if default for database)</entry>
7775+
</row>
7776+
<row>
7777+
<entry><structfield>hasindexes</structfield></entry>
7778+
<entry><type>boolean</type></entry>
7779+
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.relhasindex</literal></entry>
7780+
<entry>True if materialized view has (or recently had) any indexes</entry>
7781+
</row>
7782+
<row>
7783+
<entry><structfield>isscannable</structfield></entry>
7784+
<entry><type>boolean</type></entry>
7785+
<entry></entry>
7786+
<entry>True if materialized view can currently be scanned</entry>
7787+
</row>
7788+
<row>
7789+
<entry><structfield>definition</structfield></entry>
7790+
<entry><type>text</type></entry>
7791+
<entry></entry>
7792+
<entry>Materialized view definition (a reconstructed <command>SELECT</command> query)</entry>
7793+
</row>
7794+
</tbody>
7795+
</tgroup>
7796+
</table>
7797+
7798+
</sect1>
7799+
77187800
<sect1 id="view-pg-prepared-statements">
77197801
<title><structname>pg_prepared_statements</structname></title>
77207802

@@ -8092,7 +8174,8 @@
80928174

80938175
<para>
80948176
The <structname>pg_rules</> view excludes the <literal>ON SELECT</> rules
8095-
of views; those can be seen in <structname>pg_views</>.
8177+
of views and materialized views; those can be seen in
8178+
<structname>pg_views</> and <structname>pg_matviews</>.
80968179
</para>
80978180

80988181
</sect1>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp