/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 vote364 views1 answer
Two inner joins sql
SQL
0 vote286 views1 answer
<script>alert
SQL
1 vote398 views3 answers
Date_add mysql
SQL
0 vote476 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes362 views1 answer
Query to find table size in oracle 12c
SQL
0 vote378 views3 answers
Condition in count sql
SQL
27 votes374 views5 answers
Mysql set password for user
SQL
6 votes364 views3 answers
Oracle all dates between two dates
SQL
0 vote336 views1 answer
How to check which sp is running in sql server
SQL
3 votes404 views6 answers
DB::table('users')->get();
SQL