Postgres support (triggers)

[nene]

• CREATE TRIGGER
  • OR REPLACE
  • CONSTRAINT
  • BEFORE | AFTER | INSTEAD OF
  • event [ OR ... ]
  • event types:
    • INSERT
    • UPDATE [ OF column_name [, ... ] ]
    • DELETE
    • TRUNCATE
  • 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 )
• CREATE EVENT TRIGGER
  • ON event
  • WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ]
  • EXECUTE { FUNCTION | PROCEDURE } function_name()
• ALTER TRIGGER
  • name ON table_name
  • RENAME TO new_name
  • [ NO ] DEPENDS ON EXTENSION extension_name
• ALTER EVENT TRIGGER
  • name
  • DISABLE
  • ENABLE [ REPLICA | ALWAYS ]
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME TO new_name
• DROP TRIGGER
  • IF EXISTS
  • name ON table_name
  • CASCADE | RESTRICT
• DROP EVENT TRIGGER