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 relationship pg_constraint.conrelid = pg_class.oid? I assume the
column lists for the system tables do not include the oid column because
everyone (but us newbies) knows that every system table has an oid
column.<g>
Bill