/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

0 vote136 views1 answer
Mysql select where text contains
SQL
8 votes139 views3 answers
Duplicate entry
SQL
0 vote145 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
3 votes162 views1 answer
Sql online test questions and answers
SQL
17 votes152 views4 answers
Set mysql Password
SQL
0 vote138 views1 answer
Check if table exists oracle
SQL
0 vote147 views1 answer
Mysql terminal list table
SQL
0 vote165 views1 answer
Drop index in sql
SQL
0 vote139 views1 answer
Sql constarint
SQL
0 vote141 views1 answer
Como saber si tengo mysql instalado
SQL

Share