postgres创建分区表

-- public.table_name_XXX definition

-- Drop table

-- DROP TABLE public.table_name_XXX;

CREATE TABLE public.table_name_XXX (
	XXX varchar(10) NULL,

	dt varchar(10) not NULL
	
)
PARTITION BY RANGE (dt);


-- public.table_name_XXX_20210901 definition

-- Drop table

-- DROP TABLE public.table_name_XXX_20210901;

CREATE TABLE public.table_name_XXX_20210901 PARTITION OF public.table_name_XXX FOR VALUES FROM ('2021-09-01') TO ('2021-10-01');


-- public.table_name_XXX_20210901 foreign keys