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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: \dt doesn't show all relations in user's schemas (8.4.2)
Дата
Msg-id 22696.1261438930@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: \dt doesn't show all relations in user's schemas (8.4.2)  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Extracting SQL from logs in a usable format
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: \dt doesn't show all relations in user's schemas (8.4.2)