Обсуждение: psql: how to find out type of an index (hash, btree, ...)?

Поиск
Список
Период
Сортировка

psql: how to find out type of an index (hash, btree, ...)?

От
Michael Olivier
Дата:
How can I tell in psql client what kind of index a particular index
is? Doing a \d indexname just says "index", not the kind (hash, btree,
...)

Created using, for instance:

    create index users_acctname on users(acctname)

Will this get me a btree?

thanks,
Michael
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com