Show method of index
От | Ricardo Bessa |
---|---|
Тема | Show method of index |
Дата | |
Msg-id | ad0632c70905081320h2d1cf9cfm76d5026c443dbd3c@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Show method of index
|
Список | pgsql-hackers |
Hi,<br /><br /> I think that can be useful the command \di on psql show the method of index (hash, btree, ...) like:<br/><br /> test=# \di<br /> List of relations<br /> Schema | Name | Type | Owner | Table | Method <br /> --------+---------------+-------+------------+--------+--------<br /> public| test_id_idx | index | postgresql | table1 | btree<br /> public | test_name_idx | index | postgresql | table1| hash<br /> (2 rows)<br /> <br /> Or maybe only on \di+.<br /> <br /> test=# \di+ test_id_idx<br /> List of relations<br /> Schema | Name | Type | Owner | Table |Method | Size | Description <br /> --------+-------------+-------+------------+--------+--------+------------+-------------<br/> public | test_id_idx |index | postgresql | table1 | btree | 8192 bytes | <br /> (1 row)<br /><br /> If they wanna, i can submit the patchof this small change of psql.<br clear="all" /><br />-- <br />Ricardo Bessa<br />
В списке pgsql-hackers по дате отправления: