/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

1 vote105 views1 answer
Mysql select month and year
SQL
0 vote124 views1 answer
SQL SERVER xquery count child nodes
SQL
3 votes104 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
5 votes112 views2 answers
Create table mysql example auto_increment
SQL
1 vote96 views1 answer
Can not connect to mysql server
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL
0 vote130 views1 answer
Mysql dump with table query
SQL
6 votes110 views1 answer
Sqlite foreign key
SQL
0 vote116 views1 answer
Hibernate with springboot mysql
SQL
0 vote68 views1 answer
Mysql select top 2
SQL