/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 vote197 views1 answer
How to find columns with null values in sql
SQL
0 vote205 views1 answer
Query only first letter string
SQL
0 vote225 views1 answer
Testing sql queries
SQL
0 vote210 views1 answer
Dataframe lambda elif
SQL
0 vote255 views1 answer
Isnull in sqlite
SQL
1 vote253 views1 answer
Opensuse restart MySQL
SQL
1 vote333 views1 answer
Postgres set column based on another column
SQL
6 votes278 views1 answer
How to count number of rows in sql
SQL
0 vote196 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote196 views1 answer
Mysql streaming example
SQL

Share