/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 vote407 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote366 views1 answer
Trim leading zeros in sql
SQL
1 vote350 views1 answer
Oracle character set
SQL
1 vote360 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote349 views1 answer
Select count postgres double row count > 1
SQL
0 vote384 views3 answers
Select top 10 rows in sql
SQL
0 vote362 views1 answer
Apache Derby: Create SQL Dump with data
SQL
2 votes355 views1 answer
Mysql virtual column
SQL
1 vote341 views2 answers
Mysql insert generate serie
SQL
0 vote371 views1 answer
Command line mysql xampp
SQL