/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

4 votes183 views1 answer
Install postgres 12 on ubuntu
SQL
13 votes224 views1 answer
Views in sql
SQL
0 vote229 views3 answers
Joins and views sql
SQL
4 votes215 views1 answer
Oracle select first 10 rows
SQL
0 vote205 views1 answer
Add column to table with default value plsql
SQL
1 vote214 views1 answer
Sqlite3 read only
SQL
0 vote199 views1 answer
Selects all the columns from the sailors table
SQL
0 vote219 views1 answer
Mysql not defined
SQL
0 vote260 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote223 views1 answer
Declare date variable sql
SQL