This system catalog stores CHECK constraints on tables. (Column constraints are not treated specially. Every column constraint is equivalent to some table constraint.) See under CREATE TABLE for more information.
Table 3-16. pg_relcheck Columns
Name | Type | References | Description |
---|---|---|---|
rcrelid | oid | pg_class.oid | The table this check constraint is on |
rcname | name | Constraint name | |
rcbin | text | An internal representation of the constraint expression | |
rcsrc | text | A human-readable representation of the constraint expression |
Note: pg_class.relchecks needs to match up with the entries in this table.