Re: Quick question

Christopher Kings-Lynne <chriskl@familyhealth.com.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