pg_shdepend

The pg_shdepend catalog provides information about dependencies involving shared objects.

Column name	Data type	Description
dbid	oid (references pg_database.oid)	The OID of the database to which the dependent object belongs. 0 – A shared object.
classid	oid (references pg_class.oid)	The OID of the system catalog in which the dependent object resides.
objid	oid (references any OID column)	The OID of the specific dependent object.
objsubid	int4	The column number used when the dependency refers to a specific table column (with objid and classid pointing to the table itself). 0 – Other object types.
refclassid	oid (references pg_class.oid)	The OID of the system catalog that contains the referenced object (must be a shared catalog).
refobjid	oid (references any OID column)	The OID of the specific referenced object.
deptype	char	A code that defines the specific semantics of this dependency relationship. The possible values are: o – The referenced object (which must be a role) is the owner of the dependent object. a – The referenced object (which must be a role) appears in the ACL of the dependent object. i – The referenced object (which must be a role) appears in a pg_init_privs entry for the dependent object. r – The referenced object (which must be a role) is identified as the target of a dependent policy object. t – The referenced object (which must be a tablespace) is specified as the tablespace for a relation that lacks storage.