Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: > On 14.01.2011 10:07, Tyler Kellen wrote: >> Given two objects of the same name in different schemas, when both schemas >> are in the search_path, \d only shows the object from the first schema >> listed.
> That's intentional. \d lists the object that are currently visible in > your search_path. The object in the schema that's later in search_path > is being shadowed by the one in the first schema, so it's not visible. You can use "\d *.*" if you want to see objects that are not visible in the search path. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs