/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

1 vote116 views1 answer
Trigger in postgresql to change incoming entry
SQL
17 votes254 views4 answers
Show all tables in oracle
SQL
0 vote133 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote138 views2 answers
Drop tables from local table database postgres
SQL
2 votes118 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
5 votes123 views4 answers
Select random rows sql
SQL
0 vote129 views1 answer
Sql where part of string match
SQL
0 vote123 views1 answer
Delete insert record in sql server
SQL
4 votes140 views1 answer
Postgresql create table with index
SQL
0 vote123 views1 answer
Datagrip exec
SQL