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.

Responses

• Re: Finding the Table for Check Constraint at 2012-05-08 17:21:43 from David E. Wheeler
• Re: Finding the Table for Check Constraint at 2012-05-08 17:22:48 from Tim Bruce

pdxpug by date

Next:	From: David E. Wheeler	Date: 2012-05-08 17:21:43
	Subject: Re: Finding the Table for Check Constraint
Previous:	From: Shawn Helm	Date: 2012-05-04 17:38:04
	Subject: postgis comparison with oracle spatial