Answers for "postgres auto-increment primary key"

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

postgres autoincrement primary key

CREATE TABLE epictable
(
    mytable_key    serial primary key,
    moobars        VARCHAR(40) not null,
    foobars        DATE
);

Posted by: Guest on February-08-2022

Code answers related to "postgres auto-increment primary key"