/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

12 votes203 views2 answers
Delete all entries postgres
SQL
0 vote197 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote218 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote230 views1 answer
Sql tablo hangi sp de
SQL
2 votes193 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote216 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote320 views1 answer
Placements hackerrank solution
SQL
1 vote197 views4 answers
Fatal database postgres does not exist
SQL
0 vote200 views1 answer
Find most frequent value in SQL column
SQL
0 vote185 views1 answer
Mysql select all table that have field names
SQL