利用generate_series函数
select
'C7223818881485373' || 45 + row_number() over(order by d asc) _id,
'C722381888148537344' shift_id,
row_number() over(order by d asc) seq,
'X299841286054154240' created_by,
now() created_date,
'X299841286054154240' updated_by,
now() updated_date,
to_char(d::time,