----- "Scott Marlowe" <scott.marlowe@xxxxxxxxx> wrote: > 2009/12/21 Adrian Klaver <aklaver@xxxxxxxxxxx>: > > > > > > > > ----- "Filip Rembiałkowski" <plk.zuber@xxxxxxxxx> wrote: > >> 2009/12/19 Ralph Graulich < ralph.graulich@xxxxxxxxxxx > > >> > >> > >> > >> > >> -- 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
