Updated on 2023-10-23 GMT+08:00

DB_DEPENDENCIES

DB_DEPENDENCIES displays dependencies between functions and advanced packages accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

In GaussDB, this table is empty without any record due to information constraints.

Table 1 DB_DEPENDENCIES columns

Name

Type

Description

owner

character varying(30)

Object owner

name

character varying(30)

Object name

type

character varying(17)

Object class

referenced_owner

character varying(30)

Owner of a referenced object

referenced_name

character varying(64)

Name of a referenced object

referenced_type

character varying(17)

Type of a referenced object

referenced_link_name

character varying(128)

Name of the link to a referenced object

schemaid

numeric

ID of the current schema

dependency_type

character varying(4)

Dependency type (REF indicates soft reference and HARD indicates direct description.)