how to change postgresql sequence maximum value

Question

I have following sequence created CREATE SEQUENCE public.test_seq INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1 NO CYCLE; once it is created, i want to change the maximum value ? do i need to alter the name and create a same name sequence with maximum value ?

ALTER SEQUENCE: postgresql.org/docs/current/sql-altersequence.html — Frank Heikens
– Frank Heikens, Commented Sep 5, 2022 at 8:48

Muhammad Ali · Accepted Answer · 2022-09-05 08:51:34Z

1

Try the following command:

alter sequence test_seq maxvalue 99999;

answered Sep 5, 2022 at 8:51

Muhammad Ali

581 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

how to change postgresql sequence maximum value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related