On Mon, Jun 19, 2017 at 2:53 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johns...@gmail.com> writes: >> The docs also indicate that we don't include materialized views as >> part of "\d" which seems like an oversight somewhere. > > Where are you reading that?
https://www.postgresql.org/docs/9.6/static/app-psql.html First sentence: "For each relation (table, view, index, sequence, or foreign table) or composite type matching the pattern..." I was expecting "materialized view" to be one of the parenthetical options. > Experimentation shows that "\d" does include > matviews, and that matches the code, which has this as the default > expansion of \d: > > /* standard listing of interesting things */ > success = listTables("tvmsE", NULL, show_verbose, > show_system); > \dT / "composite type" seems to be a special case. David J. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
