Postgres Pro
Downloads
Home   >   mailing lists

psql: how to find out type of an index (hash, btree, ...)? - Mailing list pgsql-sql

From Michael Olivier
Subject psql: how to find out type of an index (hash, btree, ...)?
Date
Msg-id 19990220050429.15328.rocketmail@send1e.yahoomail.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Eric Lee Green
Date:
Subject: ...
Next
From: Michael Olivier
Date:
Subject: questions on interpreting the output of explain