/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 vote174 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote175 views1 answer
Convert rows into columns in oracle
SQL
0 vote163 views1 answer
Drop all tables db2
SQL
0 vote166 views1 answer
Mysqldump don't drop table
SQL
12 votes172 views1 answer
Docker mysql random root password
SQL
0 vote143 views1 answer
Procedures and functions in pl/sql
SQL
0 vote162 views1 answer
Mysql to get column name in database
SQL
0 vote168 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote166 views1 answer
Median mysql
SQL
0 vote181 views1 answer
MySQL get all previous date record
SQL