/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

0 vote214 views1 answer
Mysql select all where count more than"
SQL
22 votes220 views3 answers
Join three tables sql
SQL
2 votes234 views1 answer
SQL IF ELSE
SQL
0 vote225 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote236 views1 answer
Tsql find procedure with name
SQL
0 vote248 views1 answer
Postgresql create table many-to-many
SQL
1 vote226 views1 answer
Oracle stop job
SQL
0 vote225 views1 answer
Setval postgres example table id
SQL
5 votes247 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes209 views1 answer
Drop table if exists in postgres
SQL