MarshalOfficial/trigger_add.sql

Created August 28, 2022 09:27

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/MarshalOfficial/e3d7c54cdd694b7c527d64f172e11df3.js"></script>
Save MarshalOfficial/e3d7c54cdd694b7c527d64f172e11df3 to your computer and use it in GitHub Desktop.

Download ZIP

create trigger to run after insert update delete on a table and call specific function for each row

Raw

trigger_add.sql

CREATE TRIGGER user_changes AFTER INSERT OR UPDATE OR DELETE ON public.users FOR EACH ROW EXECUTE PROCEDURE change_trigger();

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment