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

From: Michael Olivier <molivier(at)yahoo(dot)com>
To: "pgsql-sql postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: psql: how to find out type of an index (hash, btree, ...)?
Date: 1999-02-20 05:04:29
Message-ID: 19990220050429.15328.rocketmail@send1e.yahoomail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Olivier 1999-02-20 05:07:48 questions on interpreting the output of explain
Previous Message D'Arcy J.M. Cain 1999-02-20 04:07:22 Re: [SQL] SQL-Query 2 get primary key