Writeable Cte

-- Delete rows while simultaneously
-- inserting them elsewhere
WITH moved_rows AS (
    DELETE FROM products
    WHERE date >= '2010-10-01' AND date < '2010-11-01'
    RETURNING *
)
INSERT INTO products_log SELECT * FROM moved_rows;

---

Backlinks

• Postgres Can Do That (DevLog)