PgSql表继承

创建一个父表

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;