Changing the sequence value of a PostgreSQL Sequence

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](http://stackoverflow.com/a/4678411/983430), or [this one](http://stackoverflow.com/a/244265/983430), or a number of others? — Amos M. Carpenter, Jul 15 '15 at 05:59
http://www.postgresql.org/docs/current/static/functions-sequence.html — a_horse_with_no_name, Jul 15 '15 at 06:20

score 2 · Accepted Answer · edited Jul 15 '15 at 06:37

2

You can ALTER the sequence using the following code:

ALTER SEQUENCE RESTART .

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

edited Jul 15 '15 at 06:37

Frank Heikens

answered Jul 15 '15 at 05:50

Yousuf Sultan

Thanks Yousuf. Will try this out and go through the manuals. – Anthony Jul 15 '15 at 05:51

1 Answers1