/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 vote143 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote149 views1 answer
Execut sql python
SQL
1 vote158 views1 answer
What is a Database?
SQL
1 vote181 views3 answers
Sql procedure
SQL
8 votes181 views1 answer
My sql version
SQL
0 vote173 views1 answer
Connect postgresql using a connection string
SQL
-1 vote139 views3 answers
Mysql get age from date
SQL
21 votes155 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
6 votes157 views2 answers
Oracle undotbs usage
SQL
2 votes161 views1 answer
Oracle to_char number format percentage
SQL