Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ DB_TRIGGERS
Updated on 2024-06-03 GMT+08:00
View PDF
Share

DB_TRIGGERS

DB_TRIGGERS displays information about triggers accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_TRIGGERS columns

Name

Type

Description

trigger_name

character varying(64)

Trigger name.

table_name

character varying(64)

Relational table name.

table_owner

character varying(64)

Role name.

status

character varying(64)

Trigger status:

  • O: The trigger is enabled in origin or local mode.
  • D: The trigger is disabled.
  • R: The trigger is enabled in replica mode.
  • A: The trigger is always enabled.
Parent topic: Other System Views