/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 vote199 views1 answer
Difference between 2 query results sql server
SQL
3 votes243 views1 answer
Oracle detect invalid password
SQL
0 vote196 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
6 votes230 views2 answers
Insert into select mysql
SQL
2 votes237 views3 answers
Sql server reseed identity column
SQL
2 votes195 views1 answer
Oracle find constraints referencing a table
SQL
3 votes198 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
4 votes193 views2 answers
Oracle set date format
SQL
0 vote209 views1 answer
How to to get time in sql
SQL
2 votes188 views2 answers
Created at and updated at in mysql
SQL