/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

8 votes187 views1 answer
Oracle search code in packages
SQL
1 vote116 views1 answer
Where database run
SQL
0 vote108 views1 answer
Sql remove last x char
SQL
17 votes131 views3 answers
Postgresql list users
SQL
3 votes127 views2 answers
How to delete git repo locally
SQL
7 votes143 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
2 votes126 views2 answers
Mysql does sentence contain word
SQL
4 votes121 views3 answers
Sqlite show columns
SQL
0 vote114 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote108 views1 answer
Mysql group rows with same value
SQL

Share