第一步,建表 父表:tablename
create table z_tablename_0 (check (fenqu=0)) INHERITS(tablename);
create table z_tablename_1 (check (fenqu=1)) INHERITS(tablename);
create table z_tablename_2 (check (fenqu=2)) INHERITS(tablename);
create table z_tablename_3 (check (fenqu=3)) INHERITS(tablename);
create table z_tablename_4 (check (fenqu=4)) INHERITS(tablename);
create table z_tablename_5 (check (fenqu=5)) INHERITS(tablename);
create table z_tablename_6 (check (fenqu=6)) INHERITS(tablename);
create table z_tablename_7 (check (fenqu=7)) INHERITS(tablename);
create table z_tablename_8 (check (fenqu=8)) INHERITS(tablename);
create table z_tablename_9 (check (fenqu=9)) INHERITS(tablename);
第二步,创建触发器函数
CREATE OR REPLACE FUNCTION tablename_insert_trigger()
RETURNS TRIGGER AS $$
BEGIN
IF (NEW.fenqu=0) THEN
INSERT INTO z_tablename_0 VALUES (NEW.*);
ELSIF (NEW.fenqu=1) THEN
INSERT INTO z_tablename_1 VA
使用hibernate和PostgreSQL进行分区
最新推荐文章于 2024-04-06 19:53:40 发布