创建一个父表
create table ta
(
sid integer not null,
pid integer not null,
cdate text not null
)
with (
OIDS=FALSE -- 不使用OID作为主键
);
ALTER table ta owner to p1;
grant all on table ta to p1;
grant select,update,insert,delete,references,trigger on table ta to p2;
再创建一个表tb继承自ta
cretate table tb
(
)
inherits (ta)
with ( OIDS =FALSE);
alter table ta owner to p1;
grant all on table ta to p1;
grant select,update,insert,delete,references,trigger on table tb to p2;
创建触发器
create trigger insert_ta_trigger
before insert
on ta
for each row
execute procedure ta_insert_trigger();
修改表的字段名
alter table ta rename sid to ssid;