/SQL/POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE

POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE

Postgresql insert select

insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;

Source: dba.stackexchange.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

POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE

##fetch data from other table with sub-query to insert it into another one

INSERT INTO PUBLIC."MyTable"(conversion_job_id, message, last_status)
VALUES (17, 'test', (SELECT status FROM PUBLIC."OtherTable" WHERE id=17))
RETURNING *

Similar codes

1 vote152 views1 answer
Install postgresql on raspberry pi
SQL
7 votes146 views2 answers
Mysql db size
SQL
0 vote168 views2 answers
Find lowest number in sql
SQL
1 vote112 views1 answer
Import in mysql without a software
SQL
6 votes154 views2 answers
Oracle trigger
SQL
1 vote139 views1 answer
Mysql history command
SQL
1 vote149 views1 answer
Where database run
SQL
-1 vote153 views1 answer
Utf8_encode mysql
SQL
16 votes155 views3 answers
Jwt secret key generator laravel
SQL
7 votes160 views1 answer
Xampp reset mysql
SQL