Column Type
Description
| | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |oid oid
Row identifier
| |conname name
Constraint name (not necessarily unique!)
| |connamespace oid (references pg\_namespace.oid)
The OID of the namespace that contains this constraint
| |contype char
c = check constraint, f = foreign key constraint, n = not-null constraint, p = primary key constraint, u = unique constraint, t = constraint trigger, x = exclusion constraint
condeferrable bool
Is the constraint deferrable?
| |condeferred bool
Is the constraint deferred by default?
| |conenforced bool
Is the constraint enforced?
| |convalidated bool
Has the constraint been validated?
| |conrelid oid (references pg\_class.oid)
The table this constraint is on; zero if not a table constraint
| |contypid oid (references pg\_type.oid)
The domain this constraint is on; zero if not a domain constraint
| |conindid oid (references pg\_class.oid)
The index supporting this constraint, if it's a unique, primary key, foreign key, or exclusion constraint; else zero
| |conparentid oid (references pg\_constraint.oid)
The corresponding constraint of the parent partitioned table, if this is a constraint on a partition; else zero
| |confrelid oid (references pg\_class.oid)
If a foreign key, the referenced table; else zero
| |confupdtype char
Foreign key update action code: a = no action, r = restrict, c = cascade, n = set null, d = set default
confdeltype char
Foreign key deletion action code: a = no action, r = restrict, c = cascade, n = set null, d = set default
confmatchtype char
Foreign key match type: f = full, p = partial, s = simple
conislocal bool
This constraint is defined locally for the relation. Note that a constraint can be locally defined and inherited simultaneously.
| |coninhcount int2
The number of direct inheritance ancestors this constraint has. A constraint with a nonzero number of ancestors cannot be dropped nor renamed.
| |connoinherit bool
This constraint is defined locally for the relation. It is a non-inheritable constraint.
| |conperiod bool
This constraint is defined with WITHOUT OVERLAPS (for primary keys and unique constraints) or PERIOD (for foreign keys).
conkey int2\[] (references pg\_attribute.attnum)
If a table constraint (including foreign keys, but not constraint triggers), list of the constrained columns
| |confkey int2\[] (references pg\_attribute.attnum)
If a foreign key, list of the referenced columns
| |conpfeqop oid\[] (references pg\_operator.oid)
If a foreign key, list of the equality operators for PK = FK comparisons
| |conppeqop oid\[] (references pg\_operator.oid)
If a foreign key, list of the equality operators for PK = PK comparisons
| |conffeqop oid\[] (references pg\_operator.oid)
If a foreign key, list of the equality operators for FK = FK comparisons
| |confdelsetcols int2\[] (references pg\_attribute.attnum)
If a foreign key with a SET NULL or SET DEFAULT delete action, the columns that will be updated. If null, all of the referencing columns will be updated.
conexclop oid\[] (references pg\_operator.oid)
If an exclusion constraint or WITHOUT OVERLAPS primary key/unique constraint, list of the per-column exclusion operators.
conbin pg\_node\_tree
If a check constraint, an internal representation of the expression. (It's recommended to use pg\_get\_constraintdef() to extract the definition of a check constraint.)