Re: BUG #18290: \di+ can not show the same name indexes

On Sun, Jan 14, 2024 at 6:33 PM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 18290
> Logged by: Yongtao Huang
> Email address: yongtaoh2022(at)gmail(dot)com
> PostgreSQL version: 16.1
> Operating system: centos7
> Description:
>
>
> gpadmin=# \di+
> List of relations
> Schema | Name | Type | Owner | Table | Persistence | Access method |
> Size | Description
> -----------+------+-------+---------+-------+-------------+---------------+------------+-------------
> pg_temp_3 | idx1 | index | gpadmin | t2 | temporary | btree |
> 8192 bytes |
> (1 row)
>
> ```
> Both table `t1` and temp table `t2` have index idx, but `\di` only shows the
> index of table `t2`.
>
> Related link: https://github.com/greenplum-db/gpdb/issues/15791
>
> Bug catcher: Hao Zhang <hao-hz(dot)zhang(at)broadcom(dot)com> and Yongtao Huang
> <yongtaoh2022(at)gmail(dot)com>
>

you can use
\set ECHO_HIDDEN
to figure out the magic behind \di

related post: https://stackoverflow.com/questions/11024099/postgresql-outputting-query-of-underlying-function