/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 vote232 views1 answer
Sql create table with references not primary key
SQL
10 votes311 views4 answers
Sql server pagination
SQL
12 votes190 views4 answers
Mysql get date difference in hours
SQL
0 vote199 views1 answer
How to create a table based on another table in mysql
SQL
0 vote195 views7 answers
Les jointures sql server
SQL
0 vote198 views1 answer
Import sql in postgresql
SQL
1 vote192 views1 answer
Round function in sql oracle
SQL
1 vote217 views1 answer
Oracle activate job
SQL
2 votes204 views2 answers
Checking data type in sql server
SQL
1 vote200 views1 answer
How to select rows with no matching entry in another table?
SQL