[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] psql \d command hides objects from "lower" schemas
From:       Josh Kupershmidt <schmiddy () gmail ! com>
Date:       2013-01-23 16:11:49
Message-ID: CAK3UJRGeH0YS7kpDDB=kXXJ0_536E=t_x1axuHPT4dwdNmqQ4w () mail ! gmail ! com
[Download RAW message or body]

On Wed, Jan 23, 2013 at 6:21 AM, Ben Morgan <neembi@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
[prev in list] [next in list] [prev in thread] [next in thread]