/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

7 votes124 views3 answers
Python and mysql connectivity
SQL
0 vote110 views2 answers
Sql count number of rows after group by
SQL
0 vote146 views2 answers
Insert data into multiple tables mysql
SQL
10 votes125 views2 answers
Show tables in schema oracle
SQL
0 vote113 views1 answer
Power query case when
SQL
3 votes128 views1 answer
Select sequence oracle
SQL
0 vote135 views1 answer
Sql last time database was accessed
SQL
1 vote115 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote133 views1 answer
Including parameters in OPENQUERY
SQL
2 votes126 views1 answer
Postgresql format date dd/mm/yyyy
SQL