Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ MY_TRIGGERS
Updated on 2025-08-19 GMT+08:00
View PDF

MY_TRIGGERS

MY_TRIGGERS displays information about the triggers owned by the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_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: System Views