/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 vote196 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
3 votes174 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote174 views1 answer
Java sql timestamp now
SQL
0 vote187 views1 answer
Create table split string function in sql server
SQL
0 vote161 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote177 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote215 views1 answer
Mysql installer no packages found
SQL
9 votes185 views2 answers
Convert data type in sql
SQL
0 vote174 views1 answer
Join in update query in mysql
SQL
0 vote167 views1 answer
Sql replace id with name from another table
SQL