↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.2 / 7.1
Historical version. PostgreSQL 7.2 has reached end of support. See the current manual.

3.16. 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-16. pg_relcheck Columns

NameTypeReferencesDescription
rcrelidoidpg_class.oidThe table this check constraint is on
rcnamename Constraint name
rcbintext An internal representation of the constraint expression
rcsrctext A human-readable representation of the constraint expression

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.