Overview

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

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_depend are applicable to every type of relation.

The following columns are available for querying in pg_depend:

ColumnTypeDescription
classidintThis column represents the OID of the system catalog the dependent object is in
objidintThis column represents the OID of the specific dependent object
objsubidintThis column represents the column number for a table column
refclassidintThis column represents the OID of the system catalog the referenced object is in
refobjidintThis column represents the OID of the specific referenced object
refobjsubidintThis column represents the column number for a table column
deptypestringunused