Re: \dt doesn't show all relations in user's schemas (8.4.2)

----- "Scott Marlowe" <scott.marlowe@gmail.com> wrote:

> 2009/12/21 Adrian Klaver <aklaver@comcast.net>:
> >
> >
> >
> > ----- "Filip Rembiałkowski" <plk.zuber@gmail.com> wrote:
> >> 2009/12/19 Ralph Graulich < ralph.graulich@t-online.de >
> >>
> >>
> >>
> >>
> >> -- Only one of the two relations is shown
> >>
> >>
> >>
> >>
> >> I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
> >>
> >>
> >>
> >>
> >
> > Try \dt *.table1
>
> While that should work, suppose you have three schemas with the same
> table, and your search path is set to look at two.  \dt by itself
> should only show the two in your search path, so it's not equivalent,
> but it is handy...

Interested in a definitive answer to this as I understood that the below held and that in order to see identical names
inmore than one schema you needed to schema qualify the names or use wildcards. 

http://www.postgresql.org/docs/8.4/static/runtime-config-client.html
When there are objects of identical names in different schemas, the one found first in the search path is used


Adrian Klaver
aklaver@comcast.net