----- "Scott Marlowe" <scott.marl...@gmail.com> wrote:
> 2009/12/21 Adrian Klaver <akla...@comcast.net>:
> >
> >
> >
> > ----- "Filip Rembiałkowski" <plk.zu...@gmail.com> wrote:
> >> 2009/12/19 Ralph Graulich < ralph.graul...@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 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
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
