/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

1 vote152 views3 answers
Postgresql connect to database
SQL
6 votes156 views2 answers
Mysql convert timestamp to date
SQL
0 vote155 views1 answer
Sql server express download
SQL
0 vote171 views1 answer
Str_to_date sql server
SQL
2 votes200 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote143 views1 answer
Sql injection mitigation
SQL
16 votes170 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
2 votes151 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote155 views1 answer
Write sql query to show the details start from digit
SQL
0 vote216 views1 answer
How to rename a database in tsql
SQL

Share