Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0C7869FA4CF for ; Tue, 7 Nov 2006 16:50:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 99796-02 for ; Tue, 7 Nov 2006 16:50:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 158219FA14D for ; Tue, 7 Nov 2006 16:50:44 -0400 (AST) Received: from D1RPQZB1 ([192.168.1.181]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id kA7KoTc27056; Tue, 7 Nov 2006 15:50:29 -0500 From: "Mark Steben" To: Cc: Subject: Re: Question Date: Tue, 7 Nov 2006 15:50:25 -0500 Message-ID: <001001c702ae$5989da00$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Thread-Index: AccCq2bBhDd/ASIWSl+UdoHu4exgsAAAof5g X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/58 X-Sequence-Number: 23585 Thank you, Jeff. That worked like a champ. My initial problem Had to do with not understanding the concept of OID datatypes. My next learning task is to read up on OID. Thanks again, Mark -----Original Message----- From: jeff@frostconsultingllc.com [mailto:jeff@frostconsultingllc.com] Sent: Tuesday, November 07, 2006 3:29 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Question On Tue, 7 Nov 2006, Mark Steben wrote: > I am very new to PostgreSQL. Is it appropriate to pose questions to this > email list? It might be better on pgsql-sql, but I'm not sure. > I am trying to come up with a query that will list the names of the database > indexes that > > Have been chosen as clustering indexes. I know I can get the INDEXRELID > from PG.INDEX > > But have yet to figure out how to get the index name from there. Any help > would be appreciated. > > And, if this is not an appropriate forum to ask questions please tell me. You want to join on pg_class.oid. You can see the info on pg_index here in the docs: http://www.postgresql.org/docs/8.1/static/catalog-pg-index.html select i.indexrelid,c.relname from pg_index i, pg_class c where i.indexrelid = c.oid; will likely give you what you're after. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954