/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

9 votes381 views1 answer
No sql
SQL
28 votes358 views4 answers
Show tables mysql
SQL
2 votes400 views2 answers
Mysql does sentence contain word
SQL
16 votes362 views3 answers
Jwt secret key generator laravel
SQL
0 vote354 views1 answer
Ignore case in string sql
SQL
0 vote438 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote405 views2 answers
Mysql limit offset
SQL
0 vote367 views1 answer
Sql value exists in column
SQL
0 vote367 views1 answer
Str_to_date sql server
SQL
0 vote431 views3 answers
Postgres trim string
SQL