/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 vote154 views1 answer
Oracle plsql sleep
SQL
0 vote67 views3 answers
Mysql calculate age from date of birth
SQL
0 vote119 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote126 views3 answers
Sql server import json
SQL
-1 vote117 views1 answer
What is in operator
SQL
3 votes118 views2 answers
Mysql time
SQL
2 votes133 views1 answer
Oracle find constraints referencing a table
SQL
8 votes126 views1 answer
Unique vs primary key
SQL
0 vote123 views1 answer
Mysql utc timestamp
SQL
1 vote132 views1 answer
Sql select row with max date
SQL