Resetting a sequence

[Vinaysohaliya]

A sequence is a database object that generates a series of unique integers. Sequences are most commonly used to produce primary key values automatically (e.g. the id column on a table).
When you create a column with type serial, bigserial, or use generated always as identity, Postgres automatically creates and manages a sequence for that column. These sequences appear on the Sequences page and can be reset the same way.

Using a sequence

Use nextval() to get the next value from a sequence:

select nextval('order_id_seq');

Use currval() to get the current value without advancing it:

select currval('order_id_seq');

What it will do -----> Enter the next value you want the sequence to use (e.g. if your data has IDs up to 999, enter 1000).

example -