/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 vote265 views1 answer
Insert using condition postgres
SQL
0 vote238 views2 answers
SQL BULK INSERT
SQL
1 vote247 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
5 votes287 views1 answer
Oracle source query
SQL
1 vote192 views1 answer
Strict in postgres SQL
SQL
3 votes198 views1 answer
Postgresql where current year
SQL
32 votes258 views6 answers
Insert select
SQL
0 vote258 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote237 views1 answer
Postgres set column based on another column
SQL
0 vote257 views1 answer
Get statis values sql
SQL