This page in other versions: Unsupported versions: 7.1 / 7.2

3.14. pg_relcheck

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-14. 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 consraint expression

Note: pg_class.relchecks needs to match up with the entries in this table.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group