/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

47 votes335 views6 answers
Add column mysql
SQL
9 votes284 views2 answers
Convert data type in sql
SQL
1 vote296 views1 answer
Select users with same username
SQL
0 vote250 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote277 views1 answer
Can't connect to postgresql mac os
SQL
0 vote282 views1 answer
How to check which table has data in mysql
SQL
18 votes268 views3 answers
Mysql number format
SQL
-1 vote252 views2 answers
On delete set default sql server
SQL
1 vote274 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote307 views1 answer
For select oracle
SQL