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

----- "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:

> 2009/12/21 Adrian Klaver <aklaver(at)comcast(dot)net>:
> >
> >
> >
> > ----- "Filip Rembiałkowski" <plk(dot)zuber(at)gmail(dot)com> wrote:
> >> 2009/12/19 Ralph Graulich < ralph(dot)graulich(at)t-online(dot)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 in more 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(at)comcast(dot)net