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

Reply via email to