/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

8 votes237 views2 answers
Change name of colum in sql table
SQL
0 vote190 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote183 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote332 views1 answer
Running mysql from bash sc
SQL
0 vote168 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote188 views3 answers
Sql drop all tables
SQL
-1 vote217 views4 answers
Postgres between dates
SQL
0 vote165 views1 answer
Psql list rules
SQL
1 vote179 views1 answer
Decalre temp table sql
SQL
0 vote166 views1 answer
Sql trim whitespace
SQL