Home > mailing lists

Thread: constraint system tables

From

mauro russo

Date:

09 May 2011, 11:08:04

Dears,

what system table contains constraints declarations/features?

Regards,

Mauro.

From

raghu ram

Date:

09 May 2011, 11:13:31

On Mon, May 9, 2011 at 4:33 PM, mauro russo <m.russo@uniplan.it> wrote:

Dears,

what system table contains constraints declarations/features?

Constraints information stored in " pg_constraint" catalog table. Use pg_get_constraintdef() to extract the definition of the check constraints.

--Raghu Ram