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 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)
PostgreSQL 8.1
- added (commit 59d1b3d9)

References

PostgreSQL documentation: pg_shdepend

Version charts

Useful overviews

Useful links

Contents

pg_shdepend

Definition by PostgreSQL version

pg_shdepend (PostgreSQL 15)

pg_shdepend (PostgreSQL 14)

pg_shdepend (PostgreSQL 13)

pg_shdepend (PostgreSQL 12)

pg_shdepend (PostgreSQL 11)

pg_shdepend (PostgreSQL 10)

pg_shdepend (PostgreSQL 9.6)

pg_shdepend (PostgreSQL 9.5)

pg_shdepend (PostgreSQL 9.4)

pg_shdepend (PostgreSQL 9.3)

pg_shdepend (PostgreSQL 9.2)

pg_shdepend (PostgreSQL 9.1)

pg_shdepend (PostgreSQL 9.0)

pg_shdepend (PostgreSQL 8.4)

pg_shdepend (PostgreSQL 8.3)

pg_shdepend (PostgreSQL 8.2)

Change history

References

Categories

See also