Khee Chin escribió:
> > 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.
Please add it to wiki.postgresql.org/wiki/CommitFestInProgress
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support