pg库建表

drop table if exists 库名.表名;
create table 库名.表名
(字段 类型
,字段 类型
) with ( OIDS=FALSE, APPENDONLY=TYPE, COMPRESSTYPE=ZLIB, COMPRESSLEVEL=5)—压缩
DISTRIBUTED BY (主键)—分布键
PARTITION BY RANGE(时间)—分区键
(partition pm_20221026start (‘2022-10-26’:: DATE) WITH ( APPENDONLY=TYPE,ORIENTATION =ROW, COMPRESSTYPE=ZLIB, COMPRESSLEVEL=5),
partition pm_20221126start (‘2022-11-26’:: DATE) end (‘2022-12-26’::DATE)WITH ( APPENDONLY=TYPE,ORIENTATION =ROW, COMPRESSTYPE=ZLIB, COMPRESSLEVEL=5)
);
comment on column 库名.表名.字段 is ‘注释’;
grant select/all on table 库名.表名 to 用户名;