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

From Tom Lane
Subject Re: Strange "missing tables" problem
Date
Msg-id 11453.1251124794@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange "missing tables" problem  (Denis BUCHER <dbucherml@hsolutions.ch>)
Responses Re: Strange "missing tables" problem  (Denis BUCHER <dbucherml@hsolutions.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: dev mas
Date:
Subject: unsubscribe
Next
From: Thomas Kellerer
Date:
Subject: Re: Getting listed on "Community Guide to PostgreSQL GUI Tools"