Mega Code Archive

 

Categories / PostgreSQL / Postgre SQL

 

Displays all indices in the connected database, with comments

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=#