How to get indexes defined on a relation ??

From: "Ramanujam H S Iyengar" <hals_ramu(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to get indexes defined on a relation ??
Date: 2004-05-17 14:08:22
Message-ID: BAY19-F25IqrfFz82bu0000c7fa@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

How can i get the Oid's of the indexes created on a given user table.
For example assume that i ahve created a table part with a primary key and
later added a index on it .
Now from the relation data structure I can get to know that there is a pkey
present ( rel->rd_rel->relhaspkey)...but .. how can i get the Oid of that
primary key index? The List rd_indexlist is showing that it is null, but my
relhaspkey is showing that there is a primary key !!

can some one educate me about this !!

Thanks,
-Ramu

_________________________________________________________________
Contact brides & grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag
Only on www.shaadi.com. Register now!

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-05-17 14:10:05 Re: Call for 7.5 feature completion
Previous Message Magnus Hagander 2004-05-17 14:03:51 Re: Table Spaces