opengauss学习的第8天

#opengauss的第八天打卡

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

create table store(

col1 int,

col2 char(20)
复制

)partition by range(c1)

(partition store_200 values less than (200),

partition store_400 values less than (400),

partition store_600 values less than (600),

partition store_800 values less than (800),

partition store_1000 values less than (1000)

);

查看分区1上的数据

select * from store partition(store_200);

重命名分区

alter table store rename partition store_200 to store_800;

select relname from pg_partition;

删除分区2

alter table store drop partition store_400;

select relname from pg_partition;

增加分区6

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

select relname from pg_partition;

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

select * from pg_partition;

删除分区表

drop table store;

\d