| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
| Cc: | francois(at)teksol(dot)info, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14578: Tables with same name in different schema are not shown with \dt |
| Date: | 2017-03-04 15:17:44 |
| Message-ID: | 20300.1488640664@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Euler Taveira <euler(at)timbira(dot)com(dot)br> writes:
> On 04-03-2017 11:51, francois(at)teksol(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2017-03-04 15:20:58 | Re: BUG #14578: Tables with same name in different schema are not shown with \dt |
| Previous Message | Euler Taveira | 2017-03-04 15:10:36 | Re: BUG #14578: Tables with same name in different schema are not shown with \dt |