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])
