/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 vote288 views1 answer
Oracle datafile max size 32gb
SQL
1 vote278 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote141 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes215 views4 answers
Psql list tables in schema
SQL
1 vote183 views1 answer
Postgresql convert text to float
SQL
0 vote209 views1 answer
Alter owner in PostgreSQL
SQL
1 vote182 views3 answers
Execute sp in sql server
SQL
0 vote238 views1 answer
Alternative for LIMIT sql
SQL
0 vote218 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote209 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL