openGauss每日一练第 8 天 | 学习心得体会

课程作业

1.创建一个含有5个分区的范围分区表store，在每个分区中插入记录

create table store(

    c1 int,

    c2 char(2)

)partition by range(c1)

(partition store_1 values less than (50),

partition store_2 values less than (100),

partition store_3 values less than (150),

partition store_4 values less than (200),

partition store_5 values less than (250)

);

2.查看分区1上的数据

select * from store partition(store_1);

3.重命名分区2

alter table store rename partition store_2 to store_6;

select relname from pg_partition;

4.删除分区5

alter table store drop partition store_5;

select relname from pg_partition;

5.增加分区6

alter table store add partition store_7 values less than (300);

select relname from pg_partition;

6.在系统表pg_partition中查看分区信息

select * from pg_partition;

7.删除分区表

drop table store;

\d