· 7 years ago · Jan 14, 2019, 03:20 PM
1create table if not exists test (
2 id serial primary;
3 test sting;
4)
5
6create or replace function test() returns trigger as $trig$
7begin
8 raise info '%', new.test;
9 return;
10end;
11$trig$ language 'plpgsql';
12
13create trigger test
14 before insert on task_dependency
15 execute procedure test();
16
17
18-- This is the insert statement:
19insert into test (name) values ("blubb");