Breaking News: Grepper is joining You.com. Read the official announcement!

postgresqk trigger

Anxious Anteater answered on July 31, 2023 Popularity 10/10 Helpfulness 2/10

answer postgresqk trigger

postgresqk trigger

Comment

CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
    ON table_name
    [ FROM referenced_table_name ]
    [ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ]
    [ REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ] ]
    [ FOR [ EACH ] { ROW | STATEMENT } ]
    [ WHEN ( condition ) ]
    EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments )

where event can be one of:

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

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.postgresql.org

Tags: sql

Link to this answer
Share Copy Link