我想用一個(gè)查詢(xún)將數(shù)據(jù)插入3個(gè)表中。我的表格如下所示:CREATE TABLE sample ( id bigserial PRIMARY KEY, lastname varchar(20), firstname varchar(20));CREATE TABLE sample1( user_id bigserial PRIMARY KEY, sample_id bigint REFERENCES sample, adddetails varchar(20));CREATE TABLE sample2( id bigserial PRIMARY KEY, user_id bigint REFERENCES sample1, value varchar(10));每次插入我都會(huì)得到一個(gè)密鑰作為回報(bào),我需要將該密鑰插入下表。我的查詢(xún)是:insert into sample(firstname,lastname) values('fai55','shaggk') RETURNING id;insert into sample1(sample_id, adddetails) values($id,'ss') RETURNING user_id;insert into sample2(user_id, value) values($id,'ss') RETURNING id;但是,如果我運(yùn)行單個(gè)查詢(xún),它們只會(huì)向我返回值,而我不能立即在下一個(gè)查詢(xún)中重用它們。如何實(shí)現(xiàn)呢?
使用Postgres一次將數(shù)據(jù)插入3個(gè)表中
心有法竹
2019-12-17 15:22:38