postgres auto increment primary key update code example

Example 1: postgresql update auto_increment value

ALTER SEQUENCE product_id_seq RESTART WITH 1453

Example 2: auto increment psql not primary key

CREATE SEQUENCE cateogry_id_seq;
ALTER TABLE category ALTER COLUMN category_id SET DEFAULT nextval('cateogry_id_seq');