Postgresql Autoincrement

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

---