Cloud

pg_constraint

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

Redpanda SQL does not support custom types.

Columns

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