Re: Strange "missing tables" problem

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

In response to

Browse pgsql-general by date

  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"