pg_constraint

Overview

The pg_constraint stores information about table constraints. It mimics the pg_constraint PostgreSQL system catalog.

Please note that Oxla doesn’t support the custom types

Columns

This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in pg_constraint are applicable to every type of relation.

The following columns are available for querying in pg_constraint:

Column	Type	Description
oid	int	This column represents the row identifier
conname	text	This column represents the constraint name
connamespace	int	This column represents the namespace that contains this constraint
contype	text	unused
condeferrable	bool	unused
condeferred	bool	unused
convalidated	bool	unused
conrelid	int	unused
contypid	int	unused
conindid	int	unused
conparentid	int	unused
confrelid	int	unused
confupdtype	text	unused
confdeltype	text	unused
confmatchtype	text	unused
conislocal	bool	unused
coninhcount	int	unused
connoinherit	bool	unused
conkey	text	unused
confkey	text	unused
conpfeqop	text	unused
conppeqop	text	unused
conffeqop	text	unused
confdelsetcols	text	unused
conexclop	text	unused
conbin	text	unused