From: | Denis BUCHER <dbucherml(at)hsolutions(dot)ch> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange "missing tables" problem |
Date: | 2009-08-24 16:23:22 |
Message-ID: | 4A92BE7A.3090201@hsolutions.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane a écrit :
> Denis BUCHER <dbucherml(at)hsolutions(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Frankel | 2009-08-24 16:31:00 | view table pkey values |
Previous Message | Raymond O'Donnell | 2009-08-24 16:09:44 | Re: Getting listed on "Community Guide to PostgreSQL GUI Tools" |