On Monday, June 10, 2024, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
>
> Is there a way to reset the sequence to the maximum
> number +1? I don't recall seeing this in the postgres docs but will look
> again.
>
https://www.postgresql.org/docs/current/functions-sequence.html
setval
The bigint argument can be computed from a query.
David J.