/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 vote154 views1 answer
Create table split string function in sql server
SQL
0 vote161 views3 answers
Postgres date difference seconds
SQL
3 votes142 views1 answer
Mssql remove column
SQL
0 vote141 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote116 views2 answers
Sql update from two different database
SQL
0 vote155 views1 answer
Mysql select row with min date
SQL
2 votes140 views1 answer
Get first 3 letters name in sql
SQL
0 vote146 views1 answer
Not between mysql
SQL
1 vote103 views1 answer
Oracle character set
SQL
0 vote141 views1 answer
Postgresql stored procedure update table values
SQL