Open yanghoon opened 6 months ago
-- IDENTITY
CREATE TABLE employees (id bigint generated by sequence value primary key(id))
INSERT INTO employees (id) values (default)
-- SEQUENCE
CREATE TABLE employees (id bigint primary key(id))
CREATE SEQUENCE employees_seq START 1 WITH 1
INSERT INTO (ID) VALUES (SELECT NEXT VALUE FOR employees_seq)