如何在postgresql中根据yyyymm生成一系列数据？

CREATE TABLE my_table (
    id SERIAL PRIMARY KEY,
    date_column DATE,
    other_column VARCHAR(255)
);

DO $$
DECLARE
    start_date DATE := '20220101';
    end_date DATE := '20221231';
    current_date DATE := start_date;
BEGIN
    WHILE current_date <= end_date LOOP
        INSERT INTO my_table (date_column, other_column)
        VALUES (current_date, 'some_value');
        
        current_date := current_date + INTERVAL '1 month';
    END LOOP;
END $$;