How do I set the value of a sequence in Postgres to max(value) + 1 for that table? [duplicate]

Question

I created a table with a SERIAL column but I also manually inserted some rows. I need to update the SERIAL so it goes to the next one.

pathikrit · Accepted Answer · 2016-07-28 18:37:10Z

1

Let's say your sequence is named $seq. If you used the SERIAL to create the table:

CREATE TABLE foo {id SERIAL, .... }

the sequence would be called something like foo_id_seq

Do this:

SELECT setval('foo_id_seq', (SELECT max(id) FROM foo), TRUE)

answered Jul 28, 2016 at 18:37

pathikrit

33.7k39 gold badges154 silver badges230 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1