示例：

创建一个范围分区表

CREATE TABLE test
(id INTEGER NOT NULL,
name CHAR(20) NOT NULL)
PARTITION BY RANGE(id)
(
PARTITION test_part1 VALUES LESS THAN(1000),
PARTITION test_part2 VALUES LESS THAN(2000),
PARTITION test_part3 VALUES LESS THAN(3000),
PARTITION test_part4 VALUES LESS THAN(4000)
);

分裂分区

ALTER TABLE test SPLIT PARTITION test_part4 AT ( 4000 ) INTO ( PARTITION test_part4_1, PARTITION test_part4_2);

增加分区

ALTER TABLE test ADD PARTITION test_part4 VALUES LESS THAN (4000);

删除分区

ALTER TABLE test DROP PARTITION test_part4;

重命令名分区

ALTER TABLE test RENAME PARTITION test_part4 TO test_part4_3;

查看分区表

SELECT * FROM PG_PARTITION WHERE PARENTID IN(SELECT PARENTID FROM PG_PARTITION WHERE RELNAME=‘test’);

语法：

删除分区：

ALTER TABLE partition_table_name DROP PARTITION partition_name;

增加分区：

ALTER TABLE partition_table_name ADD {partition_less_than_item | partition_start_end_item| partition_list_item };

重命名分区：

ALTER TABLE partition_table_name RENAME PARTITION partition_name TO partition_new_name;

分裂分区（指定切割点split_partition_value的语法）：

ALTER TABLE partition_table_name SPLIT PARTITION partition_name AT ( split_partition_value ) INTO ( PARTITION partition_new_name1, PARTITION partition_new_name2);

分裂分区（指定分区范围的语法）：

ALTER TABLE partition_table_name SPLIT PARTITION partition_name INTO { ( partition_less_than_item [, …] ) | ( partition_start_end_item [, …] ) };

合并分区：

ALTER TABLE partition_table_name MERGE PARTITIONS { partition_name } [, …] INTO PARTITION partition_name;

URL

https://docs.mogdb.io/zh/mogdb/v5.0/partition-table#%E5%88%9B%E5%BB%BAstart-end%E8%8C%83%E5%9B%B4%E5%88%86%E5%8C%BA%E8%A1%A8%E5%8F%82%E6%95%B0%E8%AF%B4%E6%98%8E