/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 vote289 views1 answer
How to check replication lag in mySQL
SQL
5 votes318 views3 answers
Oracle first day of last year
SQL
0 vote330 views1 answer
Sql convert unix time to date
SQL
0 vote322 views1 answer
Migrations.RunSQL
SQL
1 vote343 views3 answers
How to pass password to mysql command line
SQL
0 vote329 views1 answer
How to check event scheduler status mysql
SQL
3 votes306 views2 answers
Pl sql escape '
SQL
0 vote303 views1 answer
Denormalise SQL command
SQL
0 vote323 views1 answer
Restore backup mysql .gz
SQL
0 vote311 views1 answer
Get cpu details sql
SQL