auto increment id postgres 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)
Example 3: auto increment psql not primary key
CREATE SEQUENCE cateogry_id_seq;
ALTER TABLE category ALTER COLUMN category_id SET DEFAULT nextval('cateogry_id_seq');