postgresql insert from select

4 Answers Sorted by: 565 Column order does matter so if (and only if) the column orders match you can for example: insert into items_ver select * from items where item_id=2; Or if they don't match you could for example: insert into items_ver (item_id, item_group, name) select * from items where item_id=2; rise from the rubble 123