/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 vote243 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote229 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote252 views1 answer
Sql sum if
SQL
3 votes277 views1 answer
Mysql group_concat distinct
SQL
0 vote233 views1 answer
Sql select rows with different values in one column
SQL
0 vote243 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote240 views1 answer
Pagination sql
SQL
5 votes225 views1 answer
Sql first day of current year
SQL
3 votes226 views1 answer
Sql timestamp to date
SQL
0 vote239 views1 answer
Mysql update even / odd rows
SQL