CREATE TRIGGER

Name

CREATE TRIGGER -- define a new trigger

Synopsis

CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
    ON table
    [ FROM referenced_table_name ]
    { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
    [ FOR [ EACH ] { ROW | STATEMENT } ]
    [ WHEN ( condition ) ]
    EXECUTE PROCEDURE function_name ( arguments )

where event can be one of:

    INSERT
    UPDATE [ OF column_name [, ... ] ]
    DELETE
    TRUNCATE

Description

Note: The following description applies only to Postgres-XC

CREATE TRIGGER statement has not been supported in Postgres-XC yet.

See Also

CREATE FUNCTION, ALTER TRIGGER, DROP TRIGGER, SET CONSTRAINTS