/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 vote291 views1 answer
How to alter length character varying postgres
SQL
0 vote280 views1 answer
Sql not exists
SQL
2 votes305 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote303 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote307 views4 answers
Open mysql port bitnami tomact
SQL
2 votes294 views1 answer
Mysql last 7 days including today
SQL
0 vote309 views1 answer
SQL FROM-Klausel
SQL
0 vote295 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote269 views1 answer
Pl sql turn off variable substitution
SQL
7 votes282 views1 answer
Safe update mysql
SQL