Re: BUG #18290: \di+ can not show the same name indexes - Mailing list pgsql-bugs

On Sun, Jan 14, 2024 at 6:33 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      18290
> Logged by:          Yongtao Huang
> Email address:      yongtaoh2022@gmail.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.zhang@broadcom.com> and Yongtao Huang
> <yongtaoh2022@gmail.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