CREATE TRIGGER ON

CREATE TRIGER YourTriggerName ON table, view, or foreign table (postgresql.org)

Official example

CREATE TRIGGER check_update
   BEFORE UPDATE ON accounts
   FOR EACH ROW
   EXECUTE FUNCTION check_account_update();

Related terms

• CREATE VIEW
• Trigger

See also

• Trigger, CREATE TRIGGER
• CREATE [ DATABASE | INDEX | USER | ROLE | VIEW | TABLE | TRIGGER | FUNCTION | COLLATION ]
• PostgreSQL, VACUUM, Materialized Views, Triggers, Table Partitioning