postgresql auto increment 1 with alter table code example

Example 1: postgresql update auto_increment value

ALTER SEQUENCE product_id_seq RESTART WITH 1453

Example 2: postgresql auto increment

CREATE TABLE table_name(
    id SERIAL
);Code language: SQL (Structured Query Language) (sql)