/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

3 votes196 views1 answer
How to uninstall microsoft sql server
SQL
-2 votes195 views1 answer
Mysql see users and passwords
SQL
6 votes183 views1 answer
Sqlite foreign key
SQL
2 votes243 views3 answers
Mysql unix timestamp to date
SQL
1 vote200 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote187 views2 answers
Auto increment column in mysql query results
SQL
4 votes212 views6 answers
List all tables in postgres
SQL
6 votes200 views2 answers
Mysql execute file
SQL
0 vote191 views1 answer
Openquery insert into linked server
SQL
9 votes214 views3 answers
Find all tables with column name
SQL