How to create a Postgresql trigger?, in this post we will see how it works, something widely used by developers and database administrators
PostgreSQL for ubuntu
In this practical example we will use the linux operating system with an ubuntu distribution, which is widely used by database administrators, either to work on shared hosting or vps, among the most popular services are Namecheap, GoDaddy, Heroku , DreamHost among others
PostgreSQL 5432
Remember to have postgresql installed on your pc locally or on your remote server using the default port 5432
Postgresql trigger example
The first step would be to create the procedure function, we enter the graphical interface PgAdmin III or 4, or in a terminal with PSQL and add the following code
CREATE OR REPLACE FUNCTION insertstates() RETURNS trigger AS $insertcountrys$
BEGIN
insert into states (state,id_country)
values('mexico df',new.id_country);
return new;
END;
$insertcountrys$ LANGUAGE plpgsql;
Now it’s time to create the trigger which will execute the insertstates function after we insert a record into a table called countrys for this example
CREATE TRIGGER insertcountrys
AFTER INSERT ON countrys
FOR EACH ROW
EXECUTE PROCEDURE insertstates();
PostgreSQL insert into
We proceed to insert a test record
insert into countrys (id_country,country)
values(1,'mexico');
After inserting the record in the table called countrys we can verify the result
PostgreSQL select
select * from countrys;
Then we verify that the function has been executed, which would show the result on the screen
select * from states;
With these simple steps we can create trigger in postgresql