Re: Strange "missing tables" problem - Mailing list pgsql-general

From Denis BUCHER
Subject Re: Strange "missing tables" problem
Date
Msg-id 4A92BE7A.3090201@hsolutions.ch
Whole thread Raw
In response to Re: Strange "missing tables" problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Getting listed on "Community Guide to PostgreSQL GUI Tools"
Next
From: Scott Frankel
Date:
Subject: view table pkey values