From 5141603ebd162a50c36583f1a80eceadc94ef25e Mon Sep 17 00:00:00 2001
From: Kevin Grittner
Date: Wed, 6 Mar 2013 15:35:59 -0600
Subject: Add docs for pg_matviews, which were missed in the initial MV commit.
---
doc/src/sgml/catalogs.sgml | 85 +++++++++++++++++++++++++++++++++++++++++++++-
1 file changed, 84 insertions(+), 1 deletion(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 81c1be3567f..6c0ef5bd195 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -6956,6 +6956,11 @@
currently held locks
+
+ pg_matviews
+ materialized views
+
+
pg_prepared_statementsprepared statements
@@ -7715,6 +7720,83 @@
+
+ <structname>pg_matviews</structname>
+
+
+ pg_matviews
+
+
+
+ materialized views
+
+
+
+ The view pg_matviews provides access to
+ useful information about each materialized view in the database.
+
+
+
+ <structname>pg_matviews</> Columns
+
+
+
+
+ Name
+ Type
+ References
+ Description
+
+
+
+
+ schemaname
+ name
+ pg_namespace.nspname
+ Name of schema containing materialized view
+
+
+ matviewname
+ name
+ pg_class.relname
+ Name of materialized view
+
+
+ matviewowner
+ name
+ pg_authid.rolname
+ Name of materialized view's owner
+
+
+ tablespace
+ name
+ pg_tablespace.spcname
+ Name of tablespace containing materialized view (null if default for database)
+
+
+ hasindexes
+ boolean
+ pg_class.relhasindex
+ True if materialized view has (or recently had) any indexes
+
+
+ isscannable
+ boolean
+
+ True if materialized view can currently be scanned
+
+
+ definition
+ text
+
+ Materialized view definition (a reconstructed SELECT query)
+
+
+
+
+
+
+
<structname>pg_prepared_statements</structname>
@@ -8092,7 +8174,8 @@
The pg_rules view excludes the ON SELECT rules
- of views; those can be seen in pg_views.
+ of views and materialized views; those can be seen in
+ pg_views and pg_matviews.
--
cgit v1.2.3