/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

4 votes189 views1 answer
Is there any command to change postgres password
SQL
1 vote179 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote277 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote200 views1 answer
Increase date by one day in sql oracle
SQL
0 vote170 views1 answer
Mysql user set plugin
SQL
0 vote179 views1 answer
Postgres can integer fields be negative
SQL
0 vote200 views1 answer
Openquery join two tables
SQL
0 vote213 views1 answer
Reindexing all tables sql server
SQL
1 vote171 views1 answer
Base nosql
SQL
2 votes204 views1 answer
Sql get the name of user pc
SQL