/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

1 vote354 views2 answers
Sql insert timestamp
SQL
0 vote326 views1 answer
Create database store
SQL
0 vote355 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote306 views1 answer
SQL get max per id
SQL
0 vote351 views1 answer
Oracle to_number
SQL
15 votes316 views4 answers
Pl sql
SQL
0 vote332 views1 answer
Alter rename command in mysql
SQL
0 vote313 views1 answer
Concat column value of same user in mysql
SQL
0 vote331 views1 answer
Mysql enter ubuntu
SQL
11 votes358 views2 answers
Oracle source code
SQL