How to increment value in PostgreSQL?

October 4, 2023 by Tarik

UPDATE totals 
   SET total = total + 1
WHERE name="bill";

If you want to make sure the current value is indeed 203 (and not accidently increase it again) you can also add another condition:

UPDATE totals 
   SET total = total + 1
WHERE name="bill"
  AND total = 203;