我想用一個查詢將數據插入3個表中。我的表格如下所示: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));每次插入我都會得到一個密鑰作為回報,我需要將該密鑰插入下表。我的查詢是: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;但是,如果我運行單個查詢,它們只會向我返回值,而我不能立即在下一個查詢中重用它們。如何實現呢?
使用Postgres一次將數據插入3個表中
心有法竹
2019-12-17 15:22:38