PG执行插入语句后返回新生成的值
insert into table_test(id,name) values((SELECT MAX(id) FROM table_test)+1,'abc') RETURNING id
注:insert语句后接 ”RETURNING字段”可将该字段返回
参考链接
insert into table_test(id,name) values((SELECT MAX(id) FROM table_test)+1,'abc') RETURNING id
注:insert语句后接 ”RETURNING字段”可将该字段返回
参考链接