postgres=# --Displays all indices in the connected database, with comments.
postgres=# \di+
List of relations
Schema | Name | Type | Owner | Table | Description
--------+---------------+-------+----------+----------+-------------
public | subjects_pkey | index | postgres | subjects |
(1 row)
postgres=#