How to change next default value for PostgreSQL sequence? [duplicate]

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!

postgresql.org/docs/11/sql-createsequence.html

JB Nizet
– JB Nizet

2019-04-24 21:31:19 +00:00
Commented Apr 24, 2019 at 21:31 — JB Nizet
– JB Nizet, Commented Apr 24, 2019 at 21:31

abj1305 · Accepted Answer · 2019-04-25 05:38:10Z

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, 2019 at 5:38

abj1305

67510 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to change next default value for PostgreSQL sequence? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related