/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

0 vote137 views1 answer
Mysql create pool
SQL
2 votes139 views1 answer
Postgresql drop primary key constraint
SQL
24 votes135 views5 answers
Sql server insert into select
SQL
0 vote140 views3 answers
Find below average salary in sql
SQL
7 votes133 views5 answers
Oracle alter table
SQL
0 vote134 views1 answer
Select a row include list of array with join table SQL
SQL
20 votes173 views4 answers
How to find average in sql
SQL
1 vote132 views1 answer
Sql server cast date dd/mm/yyyy
SQL
2 votes136 views1 answer
Sqlite indexes
SQL
0 vote144 views1 answer
Make parameters nullable in sql server
SQL