postgres set sequence value code example

Example 1: check current sequence value postgres

SELECT last_value FROM sequence_name;

Example 2: create sequence postgres

CREATE SEQUENCE mysequence
INCREMENT 5
START 100;