/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 vote265 views1 answer
Mysql join same table multiple times group by
SQL
1 vote255 views1 answer
Oracle db create new schema
SQL
0 vote253 views1 answer
Mysql workbench not showing schemas
SQL
0 vote256 views1 answer
What is mysql_pconnect
SQL
0 vote276 views1 answer
Querry mysql by 2 columns
SQL
31 votes268 views4 answers
How to get duplicate records with multiple field in sql
SQL
-1 vote252 views3 answers
Check table exist postgresql
SQL
0 vote270 views1 answer
Top frequency in sql server
SQL
1 vote297 views2 answers
Install sql server management studio ubuntu
SQL
2 votes267 views1 answer
How to insert string variable into sqlite database
SQL