Answers for "postgres, insert rows based on select"

SQL
4

postgresql insert select

insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;
Posted by: Guest on October-08-2020
1

postgresql, Rows, INSERT INTO

INSERT INTO table_name(column1, column2, …)
VALUES (value1, value2, …)
RETURNING *;Code language: SQL (Structured Query Language) (sql)
Posted by: Guest on May-08-2021

Code answers related to "postgres, insert rows based on select"

Code answers related to "SQL"

Browse Popular Code Answers by Language