/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

50 votes248 views6 answers
Sql duplicate rows
SQL
13 votes180 views4 answers
Mysql select last 10 rows
SQL
0 vote243 views1 answer
Manage Database in MySQL
SQL
0 vote186 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote179 views1 answer
Get table which have specific columns in mysql
SQL
0 vote169 views1 answer
First Step in installing SQL workbench
SQL
3 votes184 views1 answer
How to check schema privileges in oracle
SQL
1 vote177 views1 answer
Postgresql transaction discard all
SQL
2 votes192 views1 answer
Where clause for child record apex
SQL
3 votes181 views3 answers
Stop mysql ubuntu
SQL