/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

0 vote288 views1 answer
Mysql query to select the highest value
SQL
31 votes279 views4 answers
How to get duplicate records with multiple field in sql
SQL
21 votes288 views6 answers
Change column in mysql
SQL
0 vote266 views1 answer
Sqlite3 get data from table c
SQL
0 vote285 views1 answer
Exectuer myssql .sql
SQL
0 vote282 views2 answers
Reseed sql identity
SQL
0 vote271 views1 answer
Get cpu details sql
SQL
0 vote277 views1 answer
Match end of string regex sql
SQL
0 vote293 views1 answer
How to find lowest in sql
SQL
0 vote264 views1 answer
Back up stored procedures mysql
SQL