pg_constraints

Properties
Property Value    Property Value
OID16694Total size16.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size8.0 KB
Primary key(s)Toast size8.0 KB
Estimated rows0
Comment
Columns - 24
Name Type Length Default value Allow null Unique Comment
conname name false false
connamespace oid false false
contype "char" false false
condeferrable boolean false false
condeferred boolean false false
convalidated boolean false false
conrelid oid false false
contypid oid false false
conindid oid false false
confrelid oid false false
confupdtype "char" false false
confdeltype "char" false false
confmatchtype "char" false false
conislocal boolean false false
coninhcount integer false false
connoinherit boolean false false
conkey smallint[] true false
confkey smallint[] true false
conpfeqop oid[] true false
conppeqop oid[] true false
conffeqop oid[] true false
conexclop oid[] true false
conbin pg_node_tree true false
consrc text true false
Indexes - 1
Name Primary Unique Clustered Size Definition
pg_constraints_pkey true true false 8.0 KB
btree (oid)
Foreign keys - 5
Name Keys Reference table Reference keys Match type Delete type Update type
pg_constraints_conrelid_fkey conrelid pg_class no action no action
pg_constraints_confrelid_fkey confrelid pg_class no action no action
pg_constraints_conindid_fkey conindid pg_class no action no action
pg_constraints_connamespace_fkey connamespace pg_namespace no action no action
pg_constraints_contypid_fkey contypid pg_type no action no action