Updated on 2025-07-22 GMT+08:00

ADM_TRIGGERS

ADM_TRIGGERS displays information about triggers in the database. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both 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.