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

ADM_TRIGGERS

ADM_TRIGGERS displays information about triggers in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

Table 1 ADM_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)

  • 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.