/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 vote245 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes217 views1 answer
Mysql select default if null
SQL
15 votes355 views3 answers
Postgresql change column type
SQL
0 vote195 views2 answers
Create row number in sql
SQL
8 votes241 views2 answers
How to fetch data from database without last column
SQL
0 vote219 views1 answer
Como hacer una consulta en sql
SQL
0 vote201 views1 answer
Mysql 1 hour ago
SQL
1 vote223 views1 answer
Sample in sql
SQL
4 votes197 views2 answers
Sql server date now
SQL
1 vote238 views1 answer
Mysql view curren querys
SQL