How to change next default value for PostgreSQL sequence?

Question

I have a table where the ID sequence goes like 01,02 and so on (I have a few pre-inserted values). When I try to insert a new row there (not specifying the ID explicitly, but rather values for other columns) it tells me that the default value is "1" which is the same as "01" and can't be inserted. How to fix it, thank you!

https://www.postgresql.org/docs/11/sql-createsequence.html – JB Nizet Apr 24 '19 at 21:31 — JB Nizet, Apr 24 '19 at 21:31

score 1 · Accepted Answer · answered Apr 25 '19 at 05:38

1

You can use START WITH argument while creating the sequence.

Example:

CREATE SEQUENCE sequenceName
    START WITH 1  
    INCREMENT BY 1 ;

For more documentation go through the link

answered Apr 25 '19 at 05:38

abj1305

635
9
21

How to change next default value for PostgreSQL sequence?

1 Answers1