Answers for "postgres auto increment"

SQL
-1

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
0

postgresql auto increment not working

SELECT setval('test_id_seq', (SELECT MAX(id) from "test"));
Posted by: Guest on December-02-2021

Code answers related to "postgres auto increment"

Code answers related to "SQL"

Browse Popular Code Answers by Language