alter sequence id postgres code example
Example 1: reset id sequence postgres
alter sequence <tableName>_id_seq restart with 1;
For an instance, we have a table named "groups" and we need to reset the id sequence with 1.
alter sequence groups_id_seq restart with 1;
Example 2: postgresql alter table sequence
alter sequence your_sequence restart with 1000;