# pg_constraint

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: pg_constraint
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/system-catalogs/catalogs/pg_constraint
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_constraint.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_constraint.adoc
description: The pg_constraint stores information about table constraints.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_constraint.md -->

The `pg_constraint` stores information about table constraints. It mimics the [pg\_constraint](https://www.postgresql.org/docs/current/catalog-pg-constraint.html) PostgreSQL system catalog.

> ⚠️ **WARNING**
>
> Redpanda SQL does not support custom types.

## [](#columns)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 |