/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

1 vote149 views2 answers
Mysql SELECT
SQL
0 vote132 views1 answer
Denormalise SQL command
SQL
0 vote297 views1 answer
The package java.sql is not accessible
SQL
0 vote181 views1 answer
Sql alter table add column if exists
SQL
3 votes122 views2 answers
Sql end of month
SQL
0 vote137 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
16 votes143 views3 answers
Jwt secret key generator laravel
SQL
0 vote127 views1 answer
Mysql locate
SQL
4 votes150 views2 answers
DB::transaction
SQL
0 vote132 views1 answer
Get week day name sql server
SQL