Re: Strange "missing tables" problem

Поиск
Список
Период
Сортировка
От Denis BUCHER
Тема Re: Strange "missing tables" problem
Дата
Msg-id 4A92BE7A.3090201@hsolutions.ch
обсуждение исходный текст
Ответ на Re: Strange "missing tables" problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane a écrit :
> Denis BUCHER <dbucherml@hsolutions.ch> writes:
>> Yes that's correct. Therefore my "problem" is the "normal" behavior of
>> \dt. But "normal" means "expected". But I don't find it very
>> secure/handy, because you expect to see all your tables. Is there a way
>> to change the behavior of \dt so that it lists ALL tables present in
>> search path ?
>
> It *is* the expected behavior.  The idea is that "\dt foo" should
> describe the same table that "select * from foo" would find.
> If you want to see all the possible matches for foo, use "\dt *.foo".
>
>             regards, tom lane

Oh yes, now I found the "list all tables" command :

It's :

\dt *.*

Denis

В списке pgsql-general по дате отправления:

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Getting listed on "Community Guide to PostgreSQL GUI Tools"
Следующее
От: Scott Frankel
Дата:
Сообщение: view table pkey values