/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

4 votes278 views1 answer
Sql any
SQL
0 vote289 views1 answer
Oracle query archive mode
SQL
0 vote277 views1 answer
Foreign key multiple columns
SQL
0 vote288 views1 answer
Select nth row in mysql
SQL
0 vote268 views1 answer
What is mysql_pconnect
SQL
0 vote364 views1 answer
Mysql show schema
SQL
0 vote288 views1 answer
Oracle query to find schema you are working on
SQL
1 vote287 views1 answer
Table information in sql server
SQL
0 vote290 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote271 views1 answer
Laravel general error 2006 mysql server has gone away
SQL