/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 vote130 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
1 vote119 views2 answers
How to check username in mysql command line
SQL
0 vote149 views1 answer
Sqlalchemy empty table
SQL
1 vote119 views1 answer
Too many connections mysql
SQL
79 votes295 views6 answers
Grepper code
SQL
0 vote128 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote132 views1 answer
Grant owner postgresql
SQL
2 votes132 views1 answer
Mysql time ago difference
SQL
1 vote122 views1 answer
Get rows affected mysql python
SQL
5 votes134 views1 answer
Oracle sysdate - 1 month
SQL