Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id DD9819FA18B for ; Tue, 7 Nov 2006 16:17:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 97333-04 for ; Tue, 7 Nov 2006 20:17:48 +0000 (UTC) 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 4F9F79F9B32 for ; Tue, 7 Nov 2006 16:17:45 -0400 (AST) Received: from D1RPQZB1 ([192.168.1.181]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id kA7KHdc22432 for ; Tue, 7 Nov 2006 15:17:39 -0500 From: "Mark Steben" To: Subject: Question Date: Tue, 7 Nov 2006 15:17:32 -0500 Message-ID: <000b01c702a9$c2d55d40$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C7027F.D9FF5540" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Thread-Index: AccCqcHaI3PfJ+Y0QnKYwm679EOHcw== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/53 X-Sequence-Number: 23580 This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C7027F.D9FF5540 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I am very new to PostgreSQL. Is it appropriate to pose questions to this email list? 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. Thank you, Mark Steben AutoRevenue ------=_NextPart_000_000C_01C7027F.D9FF5540 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am very new to PostgreSQL.  Is it appropriate = to pose questions to this email list?

 

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.

 

Thank you,

Mark Steben

 

AutoRevenue

------=_NextPart_000_000C_01C7027F.D9FF5540--