Re: [GENERAL] How relate pg_class to pg_constraint

2009-01-29 Thread Gregory Stark
Bill Todd writes: > I need to join pg_class and pg_constraint to get information about constraints > on a table. It appears that pg_constraint.conrelid is the foreign key but I do > not see a relid column in pg_class. What column(s) define the relationship > between these tables? Thanks. There'

Re: [GENERAL] How relate pg_class to pg_constraint

2009-01-29 Thread Bill Todd
Bill Todd wrote: I need to join pg_class and pg_constraint to get information about constraints on a table. It appears that pg_constraint.conrelid is the foreign key but I do not see a relid column in pg_class. What column(s) define the relationship between these tables? Thanks. Bill Is the