/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

16 votes303 views1 answer
Mysql smallint range
SQL
0 vote312 views1 answer
Selecting duplicates
SQL
0 vote292 views1 answer
Pgadmin see indexes
SQL
0 vote289 views1 answer
Postgresql not in alternative
SQL
10 votes307 views4 answers
Drop primary key
SQL
0 vote295 views1 answer
Sql_inner_join
SQL
0 vote307 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote297 views1 answer
Sysdate in sql
SQL
0 vote316 views1 answer
Oracle grant create job
SQL
0 vote298 views1 answer
Executescalar in sql server
SQL