How relate pg_class to pg_constraint

From: Bill Todd <pg(at)dbginc(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: How relate pg_class to pg_constraint
Date: 2009-01-29 22:00:37
Message-ID: 49822705.90606@dbginc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Todd 2009-01-29 22:08:50 Re: How relate pg_class to pg_constraint
Previous Message Karsten Hilbert 2009-01-29 20:59:02 Re: Pet Peeves?