/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 vote300 views1 answer
Mysql pad zeros
SQL
0 vote297 views1 answer
Get last updated row sql server
SQL
5 votes293 views1 answer
Migrate sql table another database
SQL
2 votes297 views3 answers
3 days back in sql server
SQL
0 vote308 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote328 views1 answer
Openquery update linked server
SQL
0 vote300 views1 answer
Mysql add comment to column
SQL
2 votes304 views1 answer
Mysql how to store lat,lng
SQL
4 votes319 views1 answer
Alter session set nls_date_format
SQL
0 vote329 views1 answer
Mysql random number between 1 and 100
SQL