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
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 |