Creating Sequence in PostgreSQL using start with nextval('old_seq')

Question

I would like to make a script in PostgreSQL to create a sequence for a table. I would like to put maximum value of another sequence as a min value of this new one. I'm trying to do this like:

create sequence test
INCREMENT 1
MINVALUE SELECT max (id) from test_table

Also I've tried:

create sequence test
INCREMENT 1
MINVALUE SELECT nextval('old_seq')

Is it even possible to do this at the point of creation?

user330315 · Accepted Answer · 2020-06-03 12:32:09Z

1

Use setval() after creating the sequence:

create sequence test INCREMENT 1;
select setval('test', nextval('old_seq'));

answered Jun 3, 2020 at 12:32

user330315

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

Collectives™ on Stack Overflow

Creating Sequence in PostgreSQL using start with nextval('old_seq')

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