/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 vote142 views1 answer
Sintaxis SELECT sql
SQL
0 vote133 views1 answer
Oracle simple quote
SQL
0 vote153 views1 answer
Str_to_date sql server
SQL
0 vote143 views1 answer
Setval postgres example table id
SQL
0 vote123 views3 answers
Sql count condition
SQL
0 vote136 views1 answer
Postgresql on conflict pair
SQL
-1 vote134 views1 answer
Mysql #1064 error
SQL
0 vote133 views1 answer
Why we have to set the password for my sql server
SQL
1 vote142 views2 answers
How to check if sql query is correct online
SQL
2 votes122 views2 answers
Get all columns from table sql
SQL