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