/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 vote143 views1 answer
Mysql wait_timeout
SQL
0 vote165 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote145 views1 answer
If column value is null then in mysql
SQL
0 vote173 views1 answer
Mysql get hour from datetime
SQL
1 vote130 views1 answer
Can we drop a primary key
SQL
2 votes141 views1 answer
Columns Present in a table
SQL
0 vote125 views1 answer
Dnsmasq.conf location macos
SQL
4 votes146 views3 answers
Mysql modify foreign key
SQL
1 vote144 views1 answer
Postgresql contains
SQL
2 votes147 views1 answer
Apex execute batch job
SQL