System Catalogs / System catalogs
pg_depend
Read the PG 18 manualThe catalog pg_depend records the dependency relationships between database objects.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
classid | oidNOT NULL | The OID of the system catalog the dependent object is in pg_class.oid |
objid | oidNOT NULL | The OID of the specific dependent object |
objsubid | int4NOT NULL | 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 | oidNOT NULL | The OID of the system catalog the referenced object is in pg_class.oid |
refobjid | oidNOT NULL | The OID of the specific referenced object |
refobjsubid | int4NOT NULL | 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 | charNOT NULL | A code defining the specific semantics of this dependency relationship; see text |
Column history across versions
Version history 5
Definition snapshot: english-manuals:71953b694f236deae10e284631f… · English manual source