Changing the sequence value of a PostgreSQL Sequence [duplicate]

Question

How can I resequence the value start of a Sequence in PostgreSQL?

What have you tried? Have you done any research? Have you seen this answer, or this one, or a number of others? — Amos M. Carpenter
– Amos M. Carpenter, Commented Jul 15, 2015 at 5:59

Frank Heikens · Accepted Answer · 2015-07-15 06:37:54Z

4

You can ALTER the sequence using the following code:

ALTER SEQUENCE RESTART .

You can go through the PostgreSQL sequence manuals at the below link:

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

answered Jul 15, 2015 at 5:50

Yousuf Sultan

3,30711 gold badges40 silver badges63 bronze badges

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

1 Comment

Thanks Yousuf. Will try this out and go through the manuals.