/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 vote146 views1 answer
Where date in datetime mysql
SQL
1 vote166 views1 answer
Sql in array query
SQL
2 votes189 views1 answer
Oracle trace session
SQL
1 vote126 views1 answer
Mysql count all table rows
SQL
0 vote157 views1 answer
Sql waitfor
SQL
0 vote142 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote146 views1 answer
Order by in codeigniter query builder
SQL
1 vote136 views1 answer
Drush sql-dump
SQL
0 vote228 views1 answer
Mysql delete entire row on condition
SQL
0 vote147 views1 answer
Ansi sql count duplicate rows
SQL