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

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