----- "Scott Marlowe" <[email protected]> wrote:
> 2009/12/21 Adrian Klaver <[email protected]>:
> >
> >
> >
> > ----- "Filip Rembiałkowski" <[email protected]> wrote:
> >> 2009/12/19 Ralph Graulich < [email protected] >
> >>
> >>
> >>
> >>
> >> -- 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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
