Received: from send1e.yahoomail.com (send1e.yahoomail.com [205.180.60.64]) by hub.org (8.9.2/8.9.1) with SMTP id AAA66635 for ; Sat, 20 Feb 1999 00:05:27 -0500 (EST) (envelope-from molivier@yahoo.com) Message-ID: <19990220050429.15328.rocketmail@send1e.yahoomail.com> Received: from [207.181.255.222] by send1e; Fri, 19 Feb 1999 21:04:29 PST Date: Fri, 19 Feb 1999 21:04:29 -0800 (PST) From: Michael Olivier Subject: psql: how to find out type of an index (hash, btree, ...)? To: "pgsql-sql postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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