On Wed, Jan 23, 2013 at 6:21 AM, Ben Morgan <nee...@gmail.com> wrote: > Given this, when using the psql command \d, I expect to see all the tables, > and the view as well as the table. But instead the objects in the front-most > schema mask the other objects. > > I'm submitting this as a bug, because it seems to be one. If this behavior > is intended, please forgive me! (And if it is intended, is there flag to > make objects in higher schemas not mask other objects?)
I think the relevant section of the docs: http://www.postgresql.org/docs/current/static/app-psql.html is the paragraph beginning: | Whenever the pattern parameter is omitted completely, the \d commands | display all objects that are visible in the current schema search | path — this is equivalent to using * as the pattern. Note, I believe that explanation is a bit lacking, i.e a plain. \d is quite different from \d * both in the format of the output, and that the latter displays pg_catalog tables. At any rate, you can use: \dtv *.* for all tables and views in all schemas. (Unfortunately, you are then stuck with noise from pg_catalog and information_schema.) Josh -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
