pgsql 创建时间维度表

create table dim_date as
select date(t) as day
from
generate_series('2000-01-01'::date,'2099-12-31', '1 days') as t;