Show method of index

From: Ricardo Bessa <ricardobessa(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Show method of index
Date: 2009-05-08 20:20:02
Message-ID: ad0632c70905081320h2d1cf9cfm76d5026c443dbd3c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Or maybe only on \di+.

test=# \di+ test_id_idx
List of relations
Schema | Name | Type | Owner | Table | Method |
Size | Description

--------+-------------+-------+------------+--------+--------+------------+-------------
public | test_id_idx | index | postgresql | table1 | btree | 8192
bytes |
(1 row)

If they wanna, i can submit the patch of this small change of psql.

--
Ricardo Bessa

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-05-08 20:20:10 Re: Some 8.4 changes needed according to pg_migrator testing
Previous Message Tom Lane 2009-05-08 19:11:07 Re: Patch to fix search_path defencies with pg_bench