/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

9 votes185 views3 answers
Where clause sql
SQL
0 vote127 views1 answer
Plsql trigger insert update
SQL
0 vote166 views1 answer
How to print mysql query of codeigniter query builder
SQL
4 votes167 views1 answer
Restart for pg_hba.conf file
SQL
0 vote155 views1 answer
Remove binlog mysql
SQL
1 vote191 views1 answer
Select inside insert query
SQL
1 vote159 views1 answer
User privileges postgresql information_schema
SQL
0 vote160 views1 answer
Psql attribute cannot login
SQL
2 votes175 views2 answers
Insert all in sql
SQL
0 vote177 views1 answer
Oracle running queries sql
SQL