pg_shdepend

The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles.

Columns 7

Column	Type	Description / reference
`dbid`	`oid`	The OID of the database the dependent object is in, or zero for a shared object pg_database.oid
`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 (must be a shared catalog) pg_class.oid
`refobjid`	`oid`	The OID of the specific referenced object
`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
`dbid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`classid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`objid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`objsubid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`refclassid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`refobjid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`deptype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 2

Definition snapshot: english-manuals:b0291cc2e487776de84c6766696… · English manual source