/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 vote107 views1 answer
Min varias colunas spark sql
SQL
0 vote100 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
-1 vote110 views4 answers
Postgres between dates
SQL
0 vote89 views1 answer
Knex last insert id mysql
SQL
0 vote107 views1 answer
Mysqlimport
SQL
0 vote116 views1 answer
Connect laravel to mysql on mac
SQL
1 vote108 views1 answer
Median mysql
SQL
5 votes100 views2 answers
Oracle to_timestamp
SQL
0 vote258 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote58 views1 answer
Calculate discount from original price sql
SQL