On this post I’m going to be covering a neat trick I learned to dynamically update multiple rows in a table with a single query. For this example I have a table called test_table and the structure looks like this: For this post I used python for the application login and pscyopg2 as the postgreSQL client. The entire script is…