/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

2 votes330 views1 answer
Set boolean flasksql
SQL
1 vote342 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
2 votes318 views2 answers
Exec procedure pl sql
SQL
1 vote333 views1 answer
Show all event schedular on mysql
SQL
0 vote343 views1 answer
How to Remove milliseconds from Date time
SQL
2 votes327 views1 answer
Oracle drop table free up space
SQL
0 vote375 views1 answer
How to get button for every record from mysql
SQL
0 vote361 views3 answers
How to assign custom id in mysql
SQL
0 vote332 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote330 views1 answer
Moodle query first user access
SQL