link
psql/create-trigger

Create Trigger

Create a new PostgreSQL trigger

trigger
create

Command

CREATE TRIGGER trigger_name AFTER INSERT ON tablename FOR EACH ROW EXECUTE FUNCTION function_name();

Examples

Create trigger for insert operation

CREATE TRIGGER trigger_name AFTER INSERT ON tablename FOR EACH ROW EXECUTE FUNCTION function_name();