> 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)
Attached is a simple patch which adds the above mentioned functionality to psql.
Regards,
Khee Chin.