/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 vote392 views1 answer
Sql server delete top 1000
SQL
2 votes373 views4 answers
2nd highest salary in mysql
SQL
0 vote365 views1 answer
Get current date data in mysql
SQL
0 vote382 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote405 views1 answer
Implode in sql query
SQL
0 vote423 views1 answer
Mysql delete entire row on condition
SQL
10 votes361 views1 answer
Oracle object dependencies
SQL
0 vote408 views1 answer
Array aggre distinct postgres
SQL
0 vote359 views1 answer
To change the database owner in SQL server
SQL
1 vote355 views1 answer
Sql find column name like
SQL