summaryrefslogtreecommitdiff
path: root/doc/src/sgml
diff options
context:
space:
mode:
authorTom Lane2017-06-19 22:32:22 +0000
committerTom Lane2017-06-19 22:32:22 +0000
commit20f67e7a29dcacd234a4deecd019a54083b8321a (patch)
treecc6dd9c8fb374d5a5a8988f80dd485a284f9d37e /doc/src/sgml
parentd063f972d23a303c32f612155b777c4674862dd6 (diff)
Fix materialized-view documentation oversights.
When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. Discussion: https://postgr.es/m/CAKFQuwb27M3VXRhHErjCpkWwN9eKThbqWb1=trtoXi9_ejqPXQ@mail.gmail.com
Diffstat (limited to 'doc/src/sgml')
-rw-r--r--doc/src/sgml/ref/psql-ref.sgml12
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 2e642265df8..4449041dcc6 100644
--- a/doc/src/sgml/ref/psql-ref.sgml
+++ b/doc/src/sgml/ref/psql-ref.sgml
@@ -953,7 +953,8 @@ testdb=>
<listitem>
<para>
- For each relation (table, view, index, sequence, or foreign table)
+ For each relation (table, view, materialized view, index, sequence,
+ or foreign table)
or composite type matching the
<replaceable class="parameter">pattern</replaceable>, show all
columns, their types, the tablespace (if not the default) and any
@@ -968,8 +969,8 @@ testdb=&gt;
<para>
For some types of relation, <literal>\d</> shows additional information
- for each column: column values for sequences, indexed expression for
- indexes and foreign data wrapper options for foreign tables.
+ for each column: column values for sequences, indexed expressions for
+ indexes, and foreign data wrapper options for foreign tables.
</para>
<para>
@@ -991,8 +992,9 @@ testdb=&gt;
<para>
If <command>\d</command> is used without a
<replaceable class="parameter">pattern</replaceable> argument, it is
- equivalent to <command>\dtvsE</command> which will show a list of
- all visible tables, views, sequences and foreign tables.
+ equivalent to <command>\dtvmsE</command> which will show a list of
+ all visible tables, views, materialized views, sequences and
+ foreign tables.
This is purely a convenience measure.
</para>
</note>