动态分配触发器名称postgresql

Question

嗨，我有一个Registration_cambios((函数；想要分配给我数据库中的所有表，我想知道你是否可以将触发器名称与我的游标的记录(表名(连接起来，使所有表上的触发器名称不相同

创建触发器示例t_log_"记录"((

CREATE OR REPLACE FUNCTION ActiveTriggers() returns  void as $$
DECLARE
 r record;
c CURSOR FOR SELECT table_name as tab FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE';

BEGIN
  FOR r IN c LOOP
        create trigger t_log_r before insert or update or delete
        on r.tab
        for each row
        execute procedure Registra_cambios();
  END LOOP;


END;
$$ LANGUAGE plpgsql;

Answer 1

类似于？。。

do
$$
declare
  r record;
begin
  for r in (SELECT table_name as tab FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE';) loop
    execute 'create trigger t_log_r_'||r.tab||' before insert or update or delete
    on '||r.tab||'
    for each row
    execute procedure Registra_cambios()';
  end loop;
end;
$$
;