| From: | Khee Chin <kheechin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Show method of index |
| Date: | 2009-05-08 22:13:38 |
| Message-ID: | 797115b80905081513o49e1e1cfk8142fdf9be567af3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda pgsql-hackers |
> 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.
Regards,
Khee Chin.
| Attachment | Content-Type | Size |
|---|---|---|
| index_patch | application/octet-stream | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-05-08 22:20:02 | Re: Show method of index |
| Previous Message | Emanuel Calvo Franco | 2009-05-08 21:47:03 | Re: Herramientas de Pruebas |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-05-08 22:18:21 | Re: strict version of version_stamp.pl |
| Previous Message | Bruce Momjian | 2009-05-08 21:55:42 | Re: Some 8.4 changes needed according to pg_migrator testing |