Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Other System Views> DB_TRIGGERS
Updated on 2024-06-03 GMT+08:00
View PDF

DB_TRIGGERS

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

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