Cloud

pg_depend

The pg_depend tracks relationships between database objects, such as tables, columns, constraints, and indexes. It mimics the pg_depend PostgreSQL system catalog.

Redpanda SQL does not support custom types.

Columns

The following columns are available for querying in pg_depend:

Column Type Description

classid

int

This column represents the OID of the system catalog the dependent object is in

objid

int

This column represents the OID of the specific dependent object

objsubid

int

This column represents the column number for a table column

refclassid

int

This column represents the OID of the system catalog the referenced object is in

refobjid

int

This column represents the OID of the specific referenced object

refobjsubid

int

This column represents the column number for a table column

deptype

text

unused