PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_depend

Read PG 18 manual ↗

The catalog pg_depend records the dependency relationships between database objects.

Kind: System catalogs
Columns in this snapshot: 7
Definition source: English manual

Columns 7

Column	Type	Description / reference
`classid`	`oid`	The OID of the system catalog the dependent object is in pg_class.oid
`objid`	`oid`	The OID of the specific dependent object
`objsubid`	`int4`	For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.
`refclassid`	`oid`	The OID of the system catalog the referenced object is in pg_class.oid
`refobjid`	`oid`	The OID of the specific referenced object
`refobjsubid`	`int4`	For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.
`deptype`	`char`	A code defining the specific semantics of this dependency relationship; see text

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`classid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`objid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`objsubid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`refclassid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`refobjid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`refobjsubid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`deptype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 2

PG 14 → 15changed
PG 13 → 14changed

Definition snapshot: english-manuals:138a56c0bd1dc1b4f51fba16b61… · English manual source