/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 vote140 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote187 views1 answer
Select count postgres double row count > 1
SQL
8 votes147 views1 answer
Oracle find text in functions
SQL
51 votes251 views6 answers
Change column name sql
SQL
0 vote165 views1 answer
Connect to ssms with python
SQL
0 vote146 views1 answer
FIND most frequent word in sql server
SQL
0 vote157 views1 answer
Postgres can integer fields be negative
SQL
22 votes156 views3 answers
How to join three tables in sql using joins
SQL
0 vote147 views2 answers
Sql having multiple conditions
SQL
4 votes150 views2 answers
Insert current date in mysql
SQL