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!
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 |