Movatterモバイル変換

oidoid

Row identifier

connamename

Constraint name (not necessarily unique!)

connamespaceoid (referencespg_namespace.oid)

The OID of the namespace that contains this constraint

contypechar

c = check constraint,f = foreign key constraint,p = primary key constraint,u = unique constraint,t = constraint trigger,x = exclusion constraint

condeferrablebool

Is the constraint deferrable?

condeferredbool

Is the constraint deferred by default?

convalidatedbool

Has the constraint been validated? Currently, can only be false for foreign keys and CHECK constraints

conrelidoid (referencespg_class.oid)

The table this constraint is on; 0 if not a table constraint

contypidoid (referencespg_type.oid)

The domain this constraint is on; 0 if not a domain constraint

conindidoid (referencespg_class.oid)

The index supporting this constraint, if it's a unique, primary key, foreign key, or exclusion constraint; else 0

conparentidoid (referencespg_constraint.oid)

The corresponding constraint in the parent partitioned table, if this is a constraint in a partition; else 0

confrelidoid (referencespg_class.oid)

If a foreign key, the referenced table; else 0

confupdtypechar

Foreign key update action code:a = no action,r = restrict,c = cascade,n = set null,d = set default

confdeltypechar

Foreign key deletion action code:a = no action,r = restrict,c = cascade,n = set null,d = set default

confmatchtypechar

Foreign key match type:f = full,p = partial,s = simple

conislocalbool

This constraint is defined locally for the relation. Note that a constraint can be locally defined and inherited simultaneously.

coninhcountint4

The number of direct inheritance ancestors this constraint has. A constraint with a nonzero number of ancestors cannot be dropped nor renamed.

connoinheritbool

This constraint is defined locally for the relation. It is a non-inheritable constraint.

conkeyint2[] (referencespg_attribute.attnum)

If a table constraint (including foreign keys, but not constraint triggers), list of the constrained columns

confkeyint2[] (referencespg_attribute.attnum)

If a foreign key, list of the referenced columns

conpfeqopoid[] (referencespg_operator.oid)

If a foreign key, list of the equality operators for PK = FK comparisons

conppeqopoid[] (referencespg_operator.oid)

If a foreign key, list of the equality operators for PK = PK comparisons

conffeqopoid[] (referencespg_operator.oid)

If a foreign key, list of the equality operators for FK = FK comparisons

conexclopoid[] (referencespg_operator.oid)

If an exclusion constraint, list of the per-column exclusion operators

conbinpg_node_tree

If a check constraint, an internal representation of the expression. (It's recommended to usepg_get_constraintdef() to extract the definition of a check constraint.)