/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

3 votes220 views2 answers
Tsql join multiple record in one string
SQL
0 vote235 views1 answer
Oracle insert single quote in string
SQL
1 vote226 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote233 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote222 views1 answer
Renommer base sql
SQL
0 vote223 views1 answer
Utiliser sql ligne de commande
SQL
0 vote220 views1 answer
Drop CHECK constraint sql
SQL
6 votes196 views1 answer
Oracle trigger after connect
SQL
2 votes215 views1 answer
Date conversion in mysql column
SQL
0 vote205 views1 answer
Update one column from another column in same table
SQL