Re: BUG #5838: tables of the same name in different schemas - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5838: tables of the same name in different schemas
Date
Msg-id 8217.1295027513@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5838: tables of the same name in different schemas  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
Heikki Linnakangas <heikki.linnakangas@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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #5838: tables of the same name in different schemas
Next
From: "Aren Cambre"
Date:
Subject: BUG #5839: pgAdmin makes bad query for creating a table when default value specified