pg_constraint

Overview

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

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	string	This column represents the constraint name
connamespace	int	This column represents the namespace that contains this constraint
contype	string	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	string	unused
confdeltype	string	unused
confmatchtype	string	unused
conislocal	bool	unused
coninhcount	int	unused
connoinherit	bool	unused
conkey	string	unused
confkey	string	unused
conpfeqop	string	unused
conppeqop	string	unused
conffeqop	string	unused
confdelsetcols	string	unused
conexclop	string	unused
conbin	string	unused