/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 vote272 views1 answer
Report in database
SQL
0 vote279 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
1 vote249 views1 answer
Mysql count words
SQL
0 vote274 views1 answer
Select multiple row from primary key sql
SQL
0 vote291 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
4 votes298 views1 answer
What are the data types
SQL
0 vote260 views1 answer
Oracle db get table sizes
SQL
0 vote251 views1 answer
Oracle archivemode
SQL
8 votes264 views3 answers
Postgres connection string
SQL
1 vote288 views1 answer
Sql count value greater than
SQL