/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 vote149 views1 answer
Unique vs distinct sql
SQL
1 vote176 views1 answer
Alphabetical order mysql
SQL
8 votes219 views1 answer
Oracle add datafile to tablespace
SQL
0 vote181 views1 answer
Possgress drop if exists view
SQL
10 votes189 views2 answers
Show tables in schema oracle
SQL
2 votes169 views2 answers
How to check database username and password in postgresql
SQL
1 vote193 views1 answer
Isnull sql server
SQL
13 votes179 views2 answers
Sqlite rename column
SQL
11 votes265 views1 answer
Oracle insert from select
SQL
5 votes182 views3 answers
Sql make column nullable
SQL

Share