Euler Taveira <euler@timbira.com.br> writes:
> On 04-03-2017 11:51, francois@teksol.info wrote:
>> In my schema, I happen to have two tables in different schemas with the same
>> name. PG supports that no problem, but when I listed the tables using \dt
>> and the search path set to both schemas, I expected to see the two tables.
>> Sadly, that wasn't the case.
> It is not a bug. It is a documented behavior [1].
Indeed. See the last discussion of this,
https://www.postgresql.org/message-id/flat/20170208113300.1411.83851%40wrigleys.postgresql.org
An approximation to what you want can be had with "\dt *.tablename"
or perhaps "\dt *.*".
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