How relate pg_class to pg_constraint - Mailing list pgsql-general

From Bill Todd
Subject How relate pg_class to pg_constraint
Date
Msg-id 49822705.90606@dbginc.com
Whole thread Raw
Responses Re: How relate pg_class to pg_constraint  (Bill Todd <pg@dbginc.com>)
Re: How relate pg_class to pg_constraint  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Pet Peeves?
Next
From: Bill Todd
Date:
Subject: Re: How relate pg_class to pg_constraint