Re: Create event triger

On 07/10/2018 02:30 AM, Łukasz Jarych wrote:
> Maybe yes,
> 
> but for me when i am learning it is not...

The example function. It is a minimal example but it should serve as a 
starting point.:

CREATE OR REPLACE FUNCTION public.add_trigger(tbl_name character varying)
  RETURNS void
  LANGUAGE plpgsql
AS $function$
BEGIN
     EXECUTE 'CREATE TRIGGER ' || quote_ident(tbl_name||'_change') || ' 
AFTER UPDATE ON ' || quote_ident(tbl_name) || ' EXECUTE PROCEDURE 
ts_update()';
END;
$function$
;

create table trg_test(id int, fld_1 varchar);

test=> \d trg_test 
 

                    Table "public.trg_test" 
 

  Column |       Type        | Collation | Nullable | Default 
 

--------+-------------------+-----------+----------+--------- 
 

  id     | integer           |           |          | 
 

  fld_1  | character varying |           |

select add_trigger('trg_test');

 
 

test=> \d trg_test 
 

                    Table "public.trg_test" 
 

  Column |       Type        | Collation | Nullable | Default 
 

--------+-------------------+-----------+----------+--------- 
 

  id     | integer           |           |          | 
 

  fld_1  | character varying |           |          | 
 

Triggers: 
 

     trg_test_change AFTER UPDATE ON trg_test FOR EACH STATEMENT EXECUTE 
PROCEDURE ts_update()



> 
> Best,
> Jacek
> 
> wt., 10 lip 2018 o 11:29 Guillaume Lelarge <guillaume@lelarge.info 


-- 
Adrian Klaver
adrian.klaver@aklaver.com