/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 vote345 views3 answers
Osx stop mysql service
SQL
16 votes380 views3 answers
T-SQL Add Column
SQL
3 votes330 views2 answers
Sql random integer
SQL
0 vote353 views1 answer
How to check which table has data in mysql
SQL
0 vote344 views4 answers
Postgresql between month
SQL
6 votes319 views1 answer
Sqlite foreign key
SQL
1 vote322 views1 answer
How to select department from table
SQL
1 vote367 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote353 views1 answer
How to query without duplicate rows in sql
SQL
0 vote336 views1 answer
Update view sql
SQL