Thanks - that's what I ended up doing. Hooray for CLUSTER indexes and
constraints in phpPgAdmin CVS now!
Chris
Tom Lane wrote:
> 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
