/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 vote227 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
22 votes298 views1 answer
Mysql workbench
SQL
1 vote219 views1 answer
Varchar plsql
SQL
0 vote231 views1 answer
How to use select union and loop
SQL
0 vote224 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote214 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote254 views1 answer
Disable database droping sql
SQL
0 vote235 views1 answer
Dump db only triggers mysql
SQL
4 votes208 views1 answer
Postgresql show current database
SQL
0 vote258 views1 answer
Mysql grant all on all databases
SQL