/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 vote294 views1 answer
Sql eliminare un record
SQL
0 vote294 views2 answers
Starting mysql service from mac
SQL
1 vote287 views1 answer
Lpad function in sql oracle
SQL
2 votes301 views2 answers
Sql percentage
SQL
0 vote335 views1 answer
Mysql create index lost connection
SQL
0 vote311 views1 answer
Check if record exists mysql
SQL
0 vote290 views1 answer
Database get 10 user aleatory
SQL
2 votes316 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
10 votes325 views2 answers
Mysql remove only_full_group_by permanently
SQL
3 votes330 views4 answers
Postgresql change timezone on timestamp without timezone
SQL