/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 vote150 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote126 views1 answer
Export partttion and import in oracle
SQL
0 vote134 views1 answer
Oracle sql winter time change
SQL
0 vote135 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote138 views1 answer
Sql select by content lenght
SQL
0 vote175 views1 answer
Mysql loop through databases and execute query
SQL
0 vote137 views1 answer
How to use sqlcommand
SQL
0 vote135 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
2 votes160 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote150 views1 answer
Typical max-connect-errors mysql
SQL