Reset sequence value as 1

Question

I need after TRUNCATE table, reset its sequence, for this I do:

 SELECT setval('mytable_id_seq', 1)

After inserting rows into a table, the sequence begins with 2 not 1

How to save a sequence value such that the new first value will be 1 ?

  SELECT setval('mytable_id_seq', 0) // gives error that value is out of range

+4

Riki May 10, '13 at 15:28

2 answers

Use the third argument to setval() :

setval(yourseq, 1, false)

Or change the sequence:

 alter sequence yourseq restart

+4

Denis de bernardy May 10, '13 at 15:36

Clodoaldo neto · Accepted Answer · 2013-05-10T15:37:14+0000

First set the minimum sequence value

 alter sequence mytable_id_seq minvalue 0 start with 1;

Now either reset it:

 SELECT setval('mytable_id_seq', 0)

Or reset when truncating:

 truncate mytable restart identity;