/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 votes124 views1 answer
Get first n letter of department name in sql
SQL
0 vote121 views1 answer
Sql join on a subquery
SQL
2 votes120 views1 answer
Mysql sysdate
SQL
0 vote115 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote133 views3 answers
Duplicate row mysql
SQL
0 vote129 views1 answer
Sql count null values in all columns
SQL
0 vote118 views2 answers
Mysql output csv
SQL
1 vote118 views1 answer
Postgres killing connections on db
SQL
0 vote120 views1 answer
Sql get month from date
SQL
0 vote119 views1 answer
T-sql email validation
SQL