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

MY_TRIGGERS

MY_TRIGGERS displays information about the triggers owned by the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_TRIGGERS columns

Name

Type

Description

owner

character varying(128)

Trigger owner.

trigger_name

character varying(64)

Trigger name.

trigger_type

character varying

Trigger types: 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)

Basic object type of a trigger, which can be table or 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 when. TRUE must be evaluated as TRIGGER_BODY to execute.

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.

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.