如何在Postgresql中设置其他列的同时，将9个随机行从一个表插入到另一个表中？

CREATE TABLE table1 (
    id SERIAL PRIMARY KEY,
    column1 VARCHAR(255),
    column2 INT,
    column3 DATE
);

CREATE TABLE table2 (
    id SERIAL PRIMARY KEY,
    column1 VARCHAR(255),
    column2 INT,
    column3 DATE
);

INSERT INTO table2 (column1, column2, column3)
SELECT column1, column2, column3
FROM table1
ORDER BY random()
LIMIT 9;

INSERT INTO table2 (column1, column2, column3, column4)
SELECT column1, column2, column3, 'example'
FROM table1
ORDER BY random()
LIMIT 9;