/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 vote189 views1 answer
Oracle decode
SQL
0 vote192 views1 answer
Restart sql server command line linux
SQL
1 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote172 views1 answer
Input in mysql
SQL
0 vote187 views1 answer
Oracle locked objects
SQL
0 vote189 views1 answer
Groupby error in mysql
SQL
-2 votes184 views1 answer
Remove root password mysql
SQL
0 vote165 views1 answer
Mod function example
SQL
2 votes178 views2 answers
Mysql limit
SQL
3 votes229 views2 answers
Synonym oracle
SQL