[HACKERS] PATCH: psql show index with type info

psql currently supports \di+ to view indexes,

                              List of relations
 Schema |        Name        | Type  | Owner |  Table  |  Size  | Description
--------+--------------------+-------+-------+---------+--------+-------------
 public | ii                 | index | amos  | i       | 131 MB |
 public | jj                 | index | amos  | i       | 12 MB  |
 public | kk                 | index | amos  | i       | 456 kB |
 public | numbers_mod2       | index | amos  | numbers | 10 MB  |
 public | numbers_mod2_btree | index | amos  | numbers | 214 MB |
(5 rows)

The co
lumn "Type" is kinda useless (all equals to index). Representing
the actual index type will be more interesting,

 Schema |        Name        |     Type     | Owner |  Table  |  Size  | Description
--------+--------------------+--------------+-------+---------+--------+-------------
 public | ii                 | index: gist  | amos  | i       | 131 MB |
 public | jj                 | index: gin   | amos  | i       | 12 MB  |
 public | kk                 | index: btree | amos  | i       | 456 kB |
 public | numbers_mod2       | index: gin   | amos  | numbers | 10 MB  |
 public | numbers_mod2_btree | index: btree | amos  | numbers | 214 MB |
(5 rows)

I'm not sure where to add documentations about this patch or if needed one. Please help
me if you think this patch is useful.

Best regards,
Amos


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers