/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 vote153 views1 answer
Drop database using terminal postgres
SQL
2 votes154 views1 answer
Sql string_agg
SQL
0 vote133 views1 answer
Set column width in sqlplus
SQL
0 vote97 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote158 views1 answer
Remove transient options sql wordpress
SQL
2 votes155 views1 answer
Merge firstname and lastname in sql oracle
SQL
3 votes140 views1 answer
Two select sql
SQL
1 vote151 views1 answer
How to print longest name in sql
SQL
0 vote133 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
5 votes156 views1 answer
Mysql where one year ago
SQL

Share