/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

2 votes287 views2 answers
Mysql limit
SQL
8 votes317 views3 answers
SQL column name
SQL
0 vote360 views1 answer
Mysql get nested records
SQL
6 votes313 views3 answers
Mysql remove user privileges
SQL
2 votes298 views1 answer
Mysql last 7 days including today
SQL
10 votes289 views1 answer
Oracle object dependencies
SQL
0 vote275 views1 answer
Sql datediff month
SQL
7 votes301 views4 answers
What is my mysql version
SQL
7 votes284 views1 answer
Safe mode mysql
SQL
0 vote268 views1 answer
Opensuse status MySQL
SQL

Share