/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 vote147 views1 answer
Mysqldump ignore table
SQL
0 vote154 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote153 views1 answer
Login failed for login due to trigger execution
SQL
0 vote154 views1 answer
Create-table-with-index-organization
SQL
0 vote170 views1 answer
View to table sql
SQL
0 vote172 views1 answer
Sqlite3 not commit
SQL
0 vote150 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes158 views2 answers
Mysql show table column comments sql
SQL
2 votes144 views1 answer
Mysql query unique column
SQL
0 vote204 views1 answer
SQL Server Enterprise
SQL

Share