Re: Show method of index - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Show method of index
Date
Msg-id 20090508222002.GM10794@alvh.no-ip.org
Whole thread Raw
In response to Re: Show method of index  (Khee Chin <kheechin@gmail.com>)
Responses Re: Show method of index  (Khee Chin <kheechin@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: strict version of version_stamp.pl
Next
From: "Joshua D. Drake"
Date:
Subject: Re: strict version of version_stamp.pl