Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > If someone could help me with this, it would be cool. How do I query > the catalogs to find the underlying index for a constraint? (Assuming > the constraint is primary or unique)
A first approximation is that the constraint and the index have the same name, but I suppose someone could break that association by renaming the index. Look in pg_depend for an internal dependency entry from the index to the constraint if you want to be sure. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])