database sequence postgresql code example

Example 1: create sequence if not exists postgres

CREATE SEQUENCE IF NOT EXISTS tbl_field_seq;

Example 2: create sequence postgres

CREATE SEQUENCE mysequence
INCREMENT 5
START 100;