Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> 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