System Catalogs / System catalogs
pg_shdepend
Read the PG 18 manualThe catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles.
Reading PG 18current·documented in 22 of 24 versions, 8.1 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 |
|---|---|---|
dbid | oidNOT NULL | The OID of the database the dependent object is in, or zero for a shared object pg_database.oid |
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 (must be a shared catalog) pg_class.oid |
refobjid | oidNOT NULL | The OID of the specific referenced object |
deptype | charNOT NULL | A code defining the specific semantics of this dependency relationship; see text |
Column history across versions
Version history 6
Definition snapshot: english-manuals:09b3608739be7a9c563cb205618… · English manual source