PostgreSQL 一句 SQL 实现删除数据后插入到历史表中

with 语句

with deleted_rows as (
    delete from t_queue where id = '12345' returning *
)
insert into t_queue_history(id, create_ts, data)
select id, create_ts, data
from deleted_rows;