Hi, I think that can be useful the command \di on psql show the method of index (hash, btree, ...) like:
test=# \di List of relations Schema | Name | Type | Owner | Table | Method --------+---------------+-------+------------+--------+-------- public | test_id_idx | index | postgresql | table1 | btree public | test_name_idx | index | postgresql | table1 | hash (2 rows) Or maybe only on \di+. test=# \di+ test_id_idx List of relations Schema | Name | Type | Owner | Table | Method | Size | Description --------+-------------+-------+------------+--------+--------+------------+------------- public | test_id_idx | index | postgresql | table1 | btree | 8192 bytes | (1 row) If they wanna, i can submit the patch of this small change of psql. -- Ricardo Bessa