pg_shdepend

A system catalogue 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 (commit 59d1b3d9).

This table is shared across all databases in a cluster.

Definition by PostgreSQL version

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

Categories

Cluster-wide table, System catalogue

See also

pg_depend, pg_shdescription