/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 vote328 views1 answer
Get foreign table names mysql
SQL
0 vote332 views1 answer
Insert output identity
SQL
1 vote360 views2 answers
Mysql update LAST_INSERT_ID()
SQL
7 votes405 views2 answers
3rd height salary sql
SQL
1 vote335 views2 answers
How to check if sql query is correct online
SQL
1 vote271 views1 answer
Oracle compile schema
SQL
7 votes387 views3 answers
Sql server check if temp table exists
SQL
1 vote334 views2 answers
Mysql filter by date mount
SQL
0 vote355 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote336 views2 answers
Regex starts with
SQL