/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 vote213 views1 answer
Sql get number of days between two dates
SQL
1 vote191 views1 answer
Oracle sql create or replace view
SQL
4 votes194 views2 answers
Dbms_scheduler stop job
SQL
0 vote200 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
-1 vote223 views1 answer
Phinehas Psalm 106
SQL
0 vote207 views1 answer
Oracle synonym procedure dblink
SQL
20 votes218 views6 answers
Mysql reset auto increment
SQL
0 vote214 views1 answer
Search from comma separated values in sql server
SQL
0 vote210 views1 answer
Normalization in database 2nd normal form
SQL
0 vote211 views1 answer
Restore backup mysql .gz
SQL