/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

3 votes283 views1 answer
Oracle list user grants
SQL
2 votes291 views1 answer
Sql string_agg
SQL
0 vote266 views1 answer
What is the use of index in mysql table
SQL
0 vote239 views2 answers
Influxdb delete measurement based on date
SQL
3 votes262 views1 answer
Oracle user quota on tablespace
SQL
0 vote283 views1 answer
Count in sql and diff
SQL
0 vote273 views1 answer
Mssql view column data type
SQL
4 votes252 views1 answer
Wilayah indonesia database
SQL
1 vote272 views1 answer
Mysql dump specific tables
SQL
0 vote257 views1 answer
Trim sql oracle
SQL

Share