/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

13 votes325 views2 answers
Sql count distinct group by
SQL
0 vote316 views1 answer
Oracle show running job
SQL
1 vote306 views1 answer
How to see all table partition in oracle
SQL
0 vote298 views2 answers
Sql select inside select
SQL
0 vote312 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote363 views1 answer
Error code 1451 sql
SQL
0 vote348 views3 answers
Postgres date difference seconds
SQL
3 votes332 views2 answers
Postgres show table schema
SQL
0 vote339 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote338 views1 answer
Drop table if exists oracle
SQL