/SQL/Postgre insert select

Postgre 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 vote133 views1 answer
Mysql get character set
SQL
0 vote135 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote162 views1 answer
How to get button for every record from mysql
SQL
0 vote144 views1 answer
Why mysql is used?
SQL
2 votes165 views1 answer
Column names in oracle sql
SQL
0 vote150 views1 answer
Oracle table free space
SQL
0 vote156 views2 answers
Mysql calcular idade
SQL
0 vote141 views2 answers
Database owner can't create new tables postgres
SQL
4 votes136 views2 answers
Sql table
SQL
0 vote152 views1 answer
Sql python hwo to pass a list in paramerter
SQL

Share