/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 vote348 views1 answer
Create date sql
SQL
-1 vote332 views1 answer
How to use update trigger in sql
SQL
13 votes373 views3 answers
List all the tables in sql
SQL
0 vote369 views2 answers
Default constraint in ms sql
SQL
4 votes344 views1 answer
Force drop all tables postgres
SQL
3 votes343 views1 answer
Mssql remove column
SQL
3 votes376 views1 answer
Two select sql
SQL
0 vote363 views1 answer
Group by max date
SQL
0 vote361 views1 answer
Get date from timestamp in mysql
SQL
0 vote394 views1 answer
Sql find gaps in date ranges
SQL