I would like to force the auto increment field of a table to some value, I tried with this:

ALTER TABLE product AUTO_INCREMENT = 1453

AND

ALTER SEQUENCE product  RESTART WITH 1453;
ERROR:  relation "your_sequence_name" does not exist

I’m new to postgres 🙁

I have a table product with Id and name field

17 Answers
17

Leave a Reply

Your email address will not be published. Required fields are marked *