/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 vote263 views1 answer
Linebreak sql
SQL
-1 vote288 views1 answer
Pl/sql how to delete a trigger
SQL
7 votes212 views1 answer
Alter table add key sql
SQL
-1 vote246 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote267 views1 answer
Hibernate show sql xml property
SQL
0 vote313 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote256 views1 answer
Redudancy in SQL
SQL
3 votes278 views1 answer
Sql print all names that start with a given letter
SQL
4 votes259 views3 answers
Oracle sql first day of quarter
SQL
6 votes252 views1 answer
Sql insert values into table
SQL