/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 vote277 views1 answer
Drop domain postgresql
SQL
1 vote288 views2 answers
Sql server add time to date
SQL
3 votes315 views5 answers
No module named 'MySQLdb'
SQL
0 vote297 views1 answer
Oracle 11g forget password
SQL
3 votes277 views1 answer
Select without null values sql
SQL
0 vote295 views1 answer
Closure in sql
SQL
0 vote318 views1 answer
Error code 1451 sql
SQL
0 vote262 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote273 views1 answer
See Foreign Key
SQL
1 vote274 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL