/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

7 votes252 views1 answer
Postgres base size
SQL
0 vote265 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
4 votes245 views2 answers
Insert current date in mysql
SQL
6 votes279 views2 answers
Sql sequence
SQL
2 votes251 views6 answers
In in sql
SQL
1 vote266 views1 answer
Pl sql insert into table
SQL
1 vote259 views1 answer
Oracle stop
SQL
0 vote263 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote268 views1 answer
Insensitive case match sqlalchemy
SQL
1 vote304 views1 answer
Import sql file from laravel
SQL