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@xxxxxxxxxxxxxxxxxxxxxx [mailto:jeff@xxxxxxxxxxxxxxxxxxxxxx] Sent: Tuesday, November 07, 2006 3:29 PM To: Mark Steben Cc: pgsql-admin@xxxxxxxxxxxxxx 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 <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
