Autoincrement
CREATE TABLE test2 (
id SERIAL,
name Text,
qty int);
INSERT INTO test2 (name,qty) VALUES('ああ',1);
INSERT INTO test2 (name,qty) VALUES('いい',-1);
INSERT INTO test2 (name,qty) VALUES('うう',2);
SELECT * FROM test2;
CREATE TABLE test3 (
id SERIAL,
sid SERIAL,
serial_id SERIAL,
name Text,
qty int);
INSERT INTO test3 (name,qty) VALUES('ああ',1);
INSERT INTO test3 (name,qty) VALUES('いい',-1);
INSERT INTO test3 (name,qty) VALUES('うう',2);
SELECT * FROM test3;
INSERT INTO public.test2(
id, sid, name, qty)
SELECT id, sid, name, qty
FROM public.test3