Re: \dt doesn't show all relations in user's schemas (8.4.2)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Ralph Graulich <ralph(dot)graulich(at)t-online(dot)de>
Subject: Re: \dt doesn't show all relations in user's schemas (8.4.2)
Date: 2009-12-21 23:42:10
Message-ID: 22696.1261438930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> So, either the docs for \dt need fixing to reflect reality, or they're
> right and psql \dt needs fixing.

The documentation says

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 the pattern *.
To see all objects in the database, use the pattern *.*.

Seems clear enough to me.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-12-22 00:00:21 Re: \dt doesn't show all relations in user's schemas (8.4.2)
Previous Message Dimitri Fontaine 2009-12-21 23:24:46 Re: Extracting SQL from logs in a usable format