Tutorial 50 - Triggers in PostgreSQL

Learn about Triggers in PostgreSQL

[Tracks]

Keep it up! Looking forward for more videos from you, don't stop!

[navin_kumar_ramalingam]

Thank you so much,
Keep posting more videos

[pewpewpew]

can you please make a video about time triggers for example i want to execute the function once a year or once a month is it possible?

[a.gm.]

could you put subtitles in it ? please

[Cupcakes]

you could prepare more visual info, first 5min is like just audio in black background

[FarsYounis]

Thank you very much, this video is very simple and useful.

[vishwaskhare]

Significance of return new in the function

[patrickknows]

Bro what if I have 12 columns and all columns are editable what is the syntax.

Because on your example it is only the address. Should I create another trigger for each item that can be edited like for example location, phone mumber etc

Can you help bro?

[kunyuchang]

-- create trigger function
create or replace function log_change()
returns trigger as
$BODY$
begin
if NEW.address<>OLD.address then
insert into emp_logs values(old.id, old.address, new.address, old.name);
end if;
return new;
end;
$BODY$
language plpgsql;

-- create trigger
create trigger loc_changer
before update
on company
for each row
execute procedure log_change();