From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Khee Chin <kheechin(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Show method of index |
Date: | 2009-05-08 22:20:02 |
Message-ID: | 20090508222002.GM10794@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ernesto Lozano | 2009-05-08 22:42:09 | Re: Herramientas de Pruebas |
Previous Message | Khee Chin | 2009-05-08 22:13:38 | Re: Show method of index |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-05-08 22:22:06 | Re: strict version of version_stamp.pl |
Previous Message | Peter Eisentraut | 2009-05-08 22:18:21 | Re: strict version of version_stamp.pl |