/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 vote230 views1 answer
Mysql take number in string
SQL
0 vote214 views2 answers
Alter table add multiple columns mysql
SQL
3 votes190 views1 answer
Insert into table from another table mysql
SQL
6 votes222 views4 answers
Mysql get random row
SQL
0 vote247 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote193 views1 answer
How to get alternate records from a table in sql
SQL
9 votes232 views3 answers
Date format in sql
SQL
0 vote250 views1 answer
Sql query for login with email or username
SQL
7 votes192 views1 answer
Forge server hosting
SQL
0 vote216 views2 answers
Import .sql into postgres db command
SQL