Alter / Update PostgreSQL Sequence

Question

How can I update the last_value field in my sequence and add 1 to it?

The query I tried: ALTER SEQUENCE "seq_hours" SET 'last_value' = 'last_value' + 1

However this did not work.

Jim Jones · Accepted Answer · 2021-08-25 13:42:53Z

1

Use setval() with a subquery to get the value from a table, e.g.

SELECT setval('seq_hours', (SELECT max(last_value)+1 FROM t));

EDIT: This solution only makes sense if you want to set the current value of a sequence based on a value from a given table. If you only want the next possible value of a sequence you should use nextval as @a_horse_with_no_name suggested (see comments)

edited Aug 25, 2021 at 13:42

answered Aug 25, 2021 at 13:29

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

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

1 Comment

user330315 Over a year ago

@yesIamFaded or simply select nextval('seq_hours')

Collectives™ on Stack Overflow

Alter / Update PostgreSQL Sequence

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related