/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 vote269 views1 answer
Set statiscis on in sql server
SQL
0 vote297 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote281 views1 answer
Mysql check datetime equals date
SQL
1 vote276 views1 answer
How to truncate a table in databse
SQL
0 vote288 views1 answer
Sqlite3 update select
SQL
0 vote295 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
2 votes276 views2 answers
Install sqlalchemy
SQL
0 vote321 views1 answer
Consecutive numbers sql
SQL
5 votes303 views3 answers
Show indexes mysql
SQL
7 votes286 views2 answers
Mysql db size
SQL