/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

4 votes128 views2 answers
How to count items with same name in sql
SQL
0 vote122 views1 answer
View acl table oracle
SQL
1 vote93 views1 answer
Convert money to varchar sql server
SQL
0 vote120 views1 answer
Mysql case when on date
SQL
0 vote123 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
13 votes131 views1 answer
Views in sql
SQL
6 votes162 views5 answers
Oracle list tablespaces
SQL
0 vote91 views1 answer
Sql select rows with simlar names
SQL
1 vote156 views1 answer
How to select random rows from a table
SQL
3 votes119 views2 answers
Sql end of month
SQL