Answers for "insert query in postgres from another table"

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 "insert query in postgres from another table"