Postgres Triggers in a Nutshell

Today we're talking about postgres triggers! Specifically insert triggers.
This is a bit of an advanced postgres tutorial. If you're newer to postgres or SQL in general check out my tutorial on the basics here:
• PostgreSQL CRASH COURS...
This is the first episode of the advanced postgres series where I dive deep on various postgresql topics such as triggers, views, materialized views, and functions. Please consider subscribing so you see my future tutorials in your feed.
Any feedback?
Leave a comment down below with any questions comments or concerns you have about the content in this video.

[@TroyAmelotte]

Full Postgres Course available for 90% off:
www.udemy.com/course/practical-postgres-master-the-most-important-parts-of-sql/?couponCode=TH-cam-PG-BEGINNER
My course is focused on the most practical parts of postgres and the goal is to teach you the most useful things as quickly as possible.

[@lukewg]

actually the best tutorial I found for this thank you so much

[@helenecklund9335]

Awesome. Thank you!

[@markodonnell3889]

Great video - thanks for sharing

[@AMasondude]

You are literally enabling me to beat my final exams, thank you very much Mr.Amelotte

[@cheskibar]

Thanks Troy. This PostgreSQL video was really helpful and so was your first one which went through the basics. I needed a quick and concise guide and yours was only 45 minutes on the YT search results so I went with yours over a 4 hours course. I would like to know more about PostgreSQL regarding the client-server model that it implements. If at some point you could go through how a simple application can sent requests to a PostgreSQL server and get back responses that would also be much appreciated.

[@pmioduszewski]

Dope video, thx!

[@SizzlingSquiggle]

I am so glad to find this video. Your energy in the video is far less boring than others. You're more informational than others and your face makes it feel more personal. This is most definitely the best video to get a quick understanding of triggers.

[@igallebedev468]

awesome video video !!!

[@RemotHuman]

also things are in cents because the simplest version of storing things in dollars would be to use float types, which can (deceptivly to beginners) produce incorrect results when you try to do calculations with them, due to the imprecision of the float type

[@nazareno.marcelli]

nice video! Thanks

[@septimusseverus252]

Like and sub well deserved....awesome video mate...thank you

[@ArunSenThomas]

Thank you for the video. Great explanation. Have you ever got a chance to explore on performance on the Postgres DB

[@RRits57]

thanks

[@plafon8596]

Thanks bro for being race clear :D

[@skeetabomb]

Does a trigger ALWAYS require a function?

[@jonathangjertsen3450]

postgres triggers in a nutshell

[@glatocha]

this explains good, but the function is complicated to understand, could you do a video on functions or just a second video on postgresql in general

[@cubano100pct]

No need to DROP TRIGGER; just do CREATE OR REPLACE TRIGGER instead