Re: Finding the Table for Check Constraint

On Tue, May 8, 2012 10:08, Brent Dombrowski wrote:
> I need to update some check constraints for a postgis migration. I can
> find the constraints I'm interested in the the pg_constraint catalog.
> However, I'm having a hell of a time trying to get the table name
> associated with the constraint. I can get the schema name and the column
> is included in the source, but the table is eluding me. Anyone have a clue
> they could send my way?
>
> Brent D.
>
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>

Look at the conrelid column in pg_constraint and compare it to the oid
column of pg_class to pull the relname field.

Tim
--
Timothy J. Bruce