Thread: How to get indexes defined on a relation ??

How to get indexes defined on a relation ??

From
"Ramanujam H S Iyengar"
Date:
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!