> 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.
index_patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
