/SQL/Postgres trigger insert into another table

Postgres trigger insert into another table

CREATE OR REPLACE FUNCTION function_copy() RETURNS TRIGGER AS
$BODY$
BEGIN
    INSERT INTO
        table2(id,name)
        VALUES(new.id,new.name);

           RETURN new;
END;
$BODY$
language plpgsql;

Source: stackoverflow.com

Postgres trigger insert into another table

CREATE TRIGGER trig_copy
     AFTER INSERT ON table1
     FOR EACH ROW
     EXECUTE PROCEDURE function_copy();

Source: stackoverflow.com

Similar codes

1 vote359 views1 answer
Postgresql define pk sequence next number
SQL
0 vote336 views1 answer
Mysql shell set time_zone
SQL
0 vote347 views1 answer
Big table in mysql
SQL
-2 votes349 views1 answer
How to open database
SQL
3 votes351 views2 answers
Get current year sql
SQL
6 votes333 views1 answer
Oracle rank() over (partition)
SQL
5 votes363 views1 answer
How to get all table names in sql query
SQL
0 vote339 views1 answer
Display first three characters sql
SQL
13 votes350 views2 answers
Sql count distinct group by
SQL
1 vote342 views1 answer
Adding a check statement in sql
SQL