/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

0 vote166 views1 answer
Sqlserver now
SQL
1 vote230 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote147 views1 answer
Mysql select where text contains
SQL
-1 vote166 views2 answers
Installing mysql on centos 7
SQL
0 vote162 views1 answer
Firebird where
SQL
3 votes160 views1 answer
Sql insert inserted id
SQL
14 votes149 views2 answers
How to auto increment in sql
SQL
3 votes151 views2 answers
Postgresql remove not null constraint
SQL
1 vote152 views1 answer
Where date = max(date) in sql
SQL
9 votes163 views5 answers
Sql delete duplicate rows but keep one
SQL

Share