postgresql insert select
snippet in sql

postgresql insert select

user2896

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

postgre insert select

user5363

insert into TABLENAMEA (A,B,C,D) 
select A,B,C,D from TABLENAMEB