/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 vote285 views3 answers
Select random sql
SQL
31 votes286 views4 answers
Mysql grant execute
SQL
0 vote275 views1 answer
Where name ends in SQL
SQL
0 vote261 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote324 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
-1 vote269 views1 answer
Ssql to lowercqse
SQL
3 votes304 views1 answer
How to add unique constraint in mysql table
SQL
0 vote258 views1 answer
Get created time of database psql 8
SQL
0 vote231 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote275 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL