/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

2 votes227 views1 answer
Oracle find constraints referencing a table
SQL
1 vote183 views1 answer
Mysql change root mysql_native_password
SQL
0 vote197 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote194 views1 answer
Column ' ' in field list is ambiguous
SQL
4 votes176 views2 answers
DB::transaction
SQL
13 votes196 views3 answers
Insert mysql ifile nto database
SQL
1 vote186 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote212 views2 answers
Starts and end with vowel sql
SQL
1 vote181 views1 answer
Type int in mysql maxlenght
SQL
0 vote195 views1 answer
Express api ith mysql data
SQL