/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

4 votes246 views2 answers
DB::transaction
SQL
0 vote179 views1 answer
C# datetime to sql server datetime
SQL
0 vote180 views1 answer
Wordpress database query change url
SQL
-1 vote171 views1 answer
Plsql while
SQL
4 votes188 views1 answer
Mysql ip address
SQL
0 vote209 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
7 votes178 views3 answers
Postgresql dump and restore db
SQL
0 vote184 views1 answer
What alter does in db
SQL
2 votes190 views1 answer
Set username and password for postgresql database
SQL
0 vote182 views1 answer
Oracle drop default value
SQL