Updated on 2024-05-07 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 both PG_CATALOG and SYS schema.

Table 1 ADM_TRIGGERS columns

Name

Type

Description

owner

character varying(128)

Trigger owner.

trigger_name

character varying(64)

Trigger name.

trigger_type

character varying

Time when a trigger is triggered. Value range: before statement, before each row, after statement, after each row, and instead of.

triggering_event

character varying

Event that triggers a trigger: update, insert, delete, and truncate.

table_owner

character varying(64)

Owner of the table that defines a trigger.

base_object_type

character varying(18)

Defines the basic object of a trigger. Value range: table and view.

table_name

character varying(64)

Name of the table or view that defines a trigger.

column_name

character varying(4000)

Not supported. Its value is NULL.

referencing_name

character varying(422)

Not supported. Its value is referencing new as new old as old.

when_clause

character varying(4000)

Content of the WHEN clause. trigger_body can be executed only when the value is true.

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.

description

character varying(4000)

Trigger description, which is used to rebuild a trigger creation statement.

action_type

character varying(11)

Action type of a trigger, which only supports call.

trigger_body

text

Statement executed when a trigger is triggered.

crossedition

character varying(7)

Not supported. Its value is NULL.

before_statement

character varying(3)

Not supported. Its value is NULL.

before_row

character varying(3)

Not supported. Its value is NULL.

after_row

character varying(3)

Not supported. Its value is NULL.

after_statement

character varying(3)

Not supported. Its value is NULL.

instead_of_row

character varying(3)

Not supported. Its value is NULL.

fire_once

character varying(3)

Not supported. Its value is NULL.

apply_server_only

character varying(3)

Not supported. Its value is NULL.