Re: \dt doesn't show all relations in user's schemas (8.4.2) - Mailing list pgsql-general

From Tom Lane
Subject Re: \dt doesn't show all relations in user's schemas (8.4.2)
Date
Msg-id 22696.1261438930@sss.pgh.pa.us
Whole thread Raw
In response to Re: \dt doesn't show all relations in user's schemas (8.4.2)  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: \dt doesn't show all relations in user's schemas (8.4.2)  (Adrian Klaver <aklaver@comcast.net>)
Re: \dt doesn't show all relations in user's schemas (8.4.2)  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe <scott.marlowe@gmail.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

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Extracting SQL from logs in a usable format
Next
From: Adrian Klaver
Date:
Subject: Re: \dt doesn't show all relations in user's schemas (8.4.2)