-- Use a sequence: CREATE SEQUENCE id_seq START WITH 1; INSERT INTO my_table (ID, VALUE) VALUES (id_seq.NEXTVAL, 'My value');