1. Home
  2. SQL

Select insert into prostgre

Code examples

1
0

postgre insert select 

insert into TABLENAMEA (A,B,C,D) 
select A,B,C,D from TABLENAMEB
1
0

insert pg result of select 

insert into items_ver (item_id, name, item_group)
select item_id, name, item_group from items where item_id=2;

Similar pages

Similar pages with examples

postgres insert result of select
select insert into prostgre
insert data from select query

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

postgres insert result of select
postgres after insert trigger example
insert into table from another table sql postgresql
insert into table if value exists in another table postgresql
set psql value from insert
postgresql parse json data
postgresql get array from json
postgres convert json string to jsonb
how to convert json to string postgres
mysql cast int to json in postgres
postgresql select to_number
cast int as numeric postgresql
how get value as numeric in postgresql
postgresql cast to int if possible
to int postgresql
postgres to_number function