pg_shdepend
A system table recording the dependency relationships between database objects and shared objects
pg_shdepend is a system catalogue table recording the dependency relationships between individual database objects and cluster-wide shared objects, such as roles.
pg_shdepend was added in PostgreSQL 8.1.
This table is shared across all databases in a cluster.
Definition by PostgreSQL version
pg_shdepend (PostgreSQL 16)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 15)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 14)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 13)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 12)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 11)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 10)
Table "pg_catalog.pg_shdepend"
Column | Type | Collation | Nullable | Default
------------+---------+-----------+----------+---------
dbid | oid | | not null |
classid | oid | | not null |
objid | oid | | not null |
objsubid | integer | | not null |
refclassid | oid | | not null |
refobjid | oid | | not null |
deptype | "char" | | not null |
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.6)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.5)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.4)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.3)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.2)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.1)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 9.0)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 8.4)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+---------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
objsubid | integer | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid, objsubid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 8.3)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+--------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
pg_shdepend (PostgreSQL 8.2)
Table "pg_catalog.pg_shdepend"
Column | Type | Modifiers
------------+--------+-----------
dbid | oid | not null
classid | oid | not null
objid | oid | not null
refclassid | oid | not null
refobjid | oid | not null
deptype | "char" | not null
Indexes:
"pg_shdepend_depender_index" btree (dbid, classid, objid), tablespace "pg_global"
"pg_shdepend_reference_index" btree (refclassid, refobjid), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_shdepend
Change history
- PostgreSQL 8.4
- column
objsubidadded (commit 3cb5d658)
- column
- PostgreSQL 8.1
- added (commit 59d1b3d9)
References
- PostgreSQL documentation: pg_shdepend
