Note: This article was originally published on my old personal blog. You can also read it there: https://engincanv.github.io/postgresql/sql/sequence/2023/02/25/postgresql-resetting-auto-increment-columns.html