/SQL/Copy column from one table to another without column duplicate postgres

Copy column from one table to another without column duplicate postgres

//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 )

Source: webscriptdev.blogspot.com

Similar codes

1 vote163 views1 answer
Nested if in mysql
SQL
0 vote178 views2 answers
Sql update top 100
SQL
0 vote192 views1 answer
Sql revert migration
SQL
0 vote179 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote192 views1 answer
Import excel to sql
SQL
0 vote209 views1 answer
Postgresql concat string with separator
SQL
0 vote182 views1 answer
Why we have to set the password for my sql server
SQL
-1 vote178 views1 answer
Mysql order by on condition
SQL
0 vote277 views1 answer
Sql if clause within where clause
SQL
0 vote212 views1 answer
How to find date from date table in sql
SQL