postgresql auto create sequence code example

Example 1: postgresql alter table sequence

alter sequence your_sequence restart with 1000;

Example 2: create sequence postgres

CREATE SEQUENCE mysequence
INCREMENT 5
START 100;