pg_shdepend
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
objsubid
added (commit 3cb5d658)
- column
- PostgreSQL 8.1
- added (commit 59d1b3d9)
References
- PostgreSQL documentation: pg_shdepend