Sunday 19 July 2020

copy column from one table to another without column duplicate postgres

if you want to update data to One table from another table without duplication of data.

//Postgres Database Query
insert into table1(column1,column2)
select c1,c2
  from table2 a
 where not exists ( select 0 from table1 b where b.id = a.id )


No comments:

Post a Comment