Let's say I have a table
item and an other one
versionned_item. From time to time, I want to copy data from
versionned_item. What I did is
WITH subset AS (SELECT ...) INSERT INTO versionned_item SELECT ... FROM subset
But in the documentation I came across the
SELECT INTO statement that seems to do the exact same thing so I am wondering if there are differences / good practices about those 2 kind of inserts.