/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 vote234 views1 answer
Oracle grant select on schema
SQL
1 vote192 views1 answer
Where not in array sql
SQL
0 vote224 views1 answer
Set Mamp mysql globally
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL
5 votes166 views1 answer
Sql first day of current year
SQL
3 votes206 views2 answers
MySQL query to get column names
SQL
0 vote180 views1 answer
Mysql xampp reset root password
SQL
13 votes180 views2 answers
Sqlite rename column
SQL
0 vote179 views1 answer
Match end of string regex sql
SQL
0 vote137 views1 answer
Psql not found windows
SQL