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.