Updated on 2024-05-07 GMT+08:00

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_owner

character varying(64)

Role name.

table_name

character varying(64)

Relational table 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.