Answers for "postgres add auto increment column"

postgresql update auto_increment value

ALTER SEQUENCE product_id_seq RESTART WITH 1453

Posted by: Guest on March-20-2020

auto increment psql not primary key

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

Posted by: Guest on December-05-2020

Code answers related to "postgres add auto increment column"