Answers for "run an insert along with a select query postgres"

postgresql insert select

insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;

Posted by: Guest on October-08-2020

postgres trigger insert into another table

CREATE TRIGGER trig_copy
     AFTER INSERT ON table1
     FOR EACH ROW
     EXECUTE PROCEDURE function_copy();

Posted by: Guest on August-22-2020

Code answers related to "run an insert along with a select query postgres"