/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 vote314 views1 answer
Mysql search multiple tables
SQL
0 vote361 views1 answer
Oracle chain step succeeded
SQL
2 votes347 views2 answers
Sqlalchemy return id after insert
SQL
0 vote327 views1 answer
Select * where id = 1,2,3
SQL
0 vote313 views1 answer
Sql developer sql worksheet not showing
SQL
51 votes545 views6 answers
Opera gx
SQL
0 vote310 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes311 views2 answers
Truncate all tables
SQL
23 votes333 views3 answers
Sql where contains part of string
SQL
0 vote343 views1 answer
Offset in postgresql example
SQL