/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

1 vote151 views1 answer
Pv mysql import
SQL
1 vote233 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote176 views1 answer
Postgresql show owner of database
SQL
0 vote182 views1 answer
Soql last week
SQL
-2 votes160 views1 answer
Modify column name in tsql
SQL
9 votes176 views3 answers
Where clause sql
SQL
0 vote178 views1 answer
Check if mysql db is used
SQL
11 votes188 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote152 views1 answer
Sql server select record with max id
SQL
0 vote153 views1 answer
Gcloud check sql
SQL