/SQL/Postgresql insert select

Postgresql insert select

Postgresql insert select

insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;

4

Source: dba.stackexchange.com

Postgre insert select

insert into TABLENAMEA (A,B,C,D) 
select A,B,C,D from TABLENAMEB

1

Source: stackoverflow.com

Similar codes

1 vote154 views2 answers
Limit sqlserver
SQL
4 votes148 views1 answer
Group by mysql and concatenate string
SQL
0 vote152 views1 answer
Sql query use select name inside where clause
SQL
2 votes181 views1 answer
Select from array in psql
SQL
0 vote133 views1 answer
Sql constarint
SQL
0 vote157 views1 answer
Mysql get only the field names in a table
SQL
0 vote139 views1 answer
How to set all the min and sec data to zero in sql server
SQL
2 votes135 views2 answers
How to view created temporary tables in mysql
SQL
0 vote133 views1 answer
Sql server split string and insert into table select
SQL
0 vote142 views1 answer
Postgres can integer fields be negative
SQL

Share