Re: Show method of index

On Tuesday 12 May 2009 08:36:20 Khee Chin wrote:
> postgres=# \di idx_foo_bt_fooi;
>                                      List of relations
>  Schema |      Name       | Type  | Owner | Table | Method |         
> Definition
> --------+-----------------+-------+-------+-------+--------+---------------
>---------------- public | idx_foo_bt_fooi | index | rubik | foo   | btree  |
> md5((a)::text), md5((a || b))
> (1 row)
>
> postgres=# \d idx_foo_bt_fooi;
>     Index "public.idx_foo_bt_fooi"
>      Column      | Type |  Definition
> -----------------+------+--------------
>  pg_expression_1 | text | md5(a::text)
>  pg_expression_2 | text | md5(a || b)
> btree, for table "public.foo"

I have committed the second part, the additions to the \d output.  I think the 
sentiment was against changing the \di output.