Chapter 38. Event Triggers

   Table of Contents

   38.1. Overview of Event Trigger Behavior

        38.1.1. login
        38.1.2. ddl_command_start
        38.1.3. ddl_command_end
        38.1.4. sql_drop
        38.1.5. table_rewrite
        38.1.6. Event Triggers in Aborted Transactions
        38.1.7. Creating Event Triggers

   38.2. Writing Event Trigger Functions in C
   38.3. A Complete Event Trigger Example
   38.4. A Table Rewrite Event Trigger Example
   38.5. A Database Login Event Trigger Example

   To supplement the trigger mechanism discussed in Chapter 37, PostgreSQL
   also provides event triggers. Unlike regular triggers, which are
   attached to a single table and capture only DML events, event triggers
   are global to a particular database and are capable of capturing DDL
   events.

   Like regular triggers, event triggers can be written in any procedural
   language that includes event trigger support, or in C, but not in plain
   SQL.