On conflict Do Something Clause in Postgres

InstructorTyler Clark

Share this video with your friends

Send Tweet

Instead of first checking to see if a record already exists within your table, we can do a on conflict do update. In this command, we can ether insert a row into our table, if it does exist, then check to see if all of the columns match up. This saves us a database call and is pretty straightforward to understand.