Re: Show method of index

Ricardo Bessa 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)

Well, you can see that with \d on the table, but IMHO this should be
present on \di too, so +1.

One gripe I had with \d and indexes the other day is that it sucks on
functional indexes -- it just says "pg_expression_1".

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.