如何在不存在递增列值的情况下复制行和递增列？

-- 假设原表名为 original_table，目标列为 id
CREATE TEMP TABLE temp_table AS SELECT * FROM original_table WHERE 1=0;

-- 插入数据并递增 id 列
INSERT INTO temp_table (column1, column2, id)
SELECT column1, column2, nextval('temp_id_seq') AS id
FROM original_table;

-- 将临时表的数据插入回原表
INSERT INTO original_table (column1, column2, id)
SELECT column1, column2, id FROM temp_table;

WITH numbered_rows AS (
    SELECT column1, column2, ROW_NUMBER() OVER () AS new_id
    FROM original_table
)
INSERT INTO original_table (column1, column2, id)
SELECT column1, column2, new_id
FROM numbered_rows;

from sqlalchemy import create_engine, Table, MetaData

engine = create_engine('your_database_connection_string')
metadata = MetaData(bind=engine)
original_table = Table('original_table', metadata, autoload_with=engine)

# 读取数据
with engine.connect() as conn:
    result = conn.execute(original_table.select())
    rows = result.fetchall()

# 递增 id 列并写回数据
new_id = max(row['id'] for row in rows) + 1 if rows else 1
for row in rows:
    new_row = {**row, 'id': new_id}
    new_id += 1
    conn.execute(original_table.insert().values(new_row))