Skip site navigation (1) Skip section navigation (2)

Re: Show method of index

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 (view raw or flat)
Thread:
Lists: pgsql-es-ayudapgsql-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: index_patch
Description: application/octet-stream (1.2 KB)

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2009-05-08 22:18:21
Subject: Re: strict version of version_stamp.pl
Previous:From: Bruce MomjianDate: 2009-05-08 21:55:42
Subject: Re: Some 8.4 changes needed according to pg_migrator testing

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2009-05-08 22:20:02
Subject: Re: Show method of index
Previous:From: Emanuel Calvo FrancoDate: 2009-05-08 21:47:03
Subject: Re: Herramientas de Pruebas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group