Re: Unexpected omission of tables with duplicate names across schemas

Chris Ross <cross@markmonitor.com> writes:
>    When there is a table (or view, or sequence) of the same name in one
> schema as another, and both of these schemas are in the set search_path,
> only the first schema in the search path will show that name in the
> output of \d[S+].  (Also \dt, \dv, etc)

That's the intended behavior, because only the first one is actually
accessible without schema-qualifying its name.  You can use a pattern
of "*.*" if you want to see objects that are hidden according to the
search path.  The default behavior is equivalent to a pattern of "*",
which only shows objects reachable with unqualified names.

            regards, tom lane