Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.49 USER_TRIGGERS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.49 USER_TRIGGERS

The USER_TRIGGERS view displays information about all triggers on tables owned by the current user.

Name

Type

Description

trigger_name

TEXT

The name of the trigger.

trigger_type

TEXT

The type of the trigger. Possible values are:

      BEFORE ROW

      BEFORE STATEMENT

      AFTER ROW

      AFTER STATEMENT

triggering_event

TEXT

The event that fires the trigger.

table_owner

TEXT

The user name of the owner of the table on which the trigger is defined.

base_object_type

TEXT

Included for compatibility only. Value will always be TABLE.

table_name

TEXT

The name of the table on which the trigger is defined.

referencing_name

TEXT

Included for compatibility only. Value will always be REFERENCING NEW AS NEW OLD AS OLD.

status

TEXT

Status indicates if the trigger is enabled (VALID) or disabled (NOTVALID).

description

TEXT

Included for compatibility only. Value will always be SEE TRIGGER BODY FOR TEXT.

trigger_body

TEXT

The body of the trigger.

action_statement

TEXT

The SQL command that executes when the trigger fires.

Previous PageTable Of ContentsNext Page