/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

7 votes138 views3 answers
How to check table name in current database sql
SQL
2 votes147 views2 answers
Sqlite_busy: database is locked
SQL
1 vote145 views2 answers
Mysql join two tables
SQL
-2 votes152 views3 answers
Sqlite reset autoincrement
SQL
3 votes142 views2 answers
WhereIn SQL
SQL
39 votes224 views4 answers
Select duplicates in sql
SQL
5 votes139 views1 answer
How to get all dates in a month in oracle
SQL
5 votes134 views1 answer
Oracle scan source ddl
SQL
0 vote157 views1 answer
Sql server union if table exist
SQL
0 vote180 views1 answer
Plpgsql create function
SQL