/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 vote119 views1 answer
Neo4j command to run script file
SQL
-1 vote122 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote116 views2 answers
Sql trigger difference between for and after
SQL
2 votes99 views2 answers
Compare date mysql
SQL
5 votes113 views2 answers
Oracle tables with column name
SQL
0 vote138 views1 answer
Sql get latest of 2 datetimes
SQL
19 votes111 views6 answers
What is mySQL
SQL
0 vote109 views1 answer
Stored procedures example
SQL
16 votes113 views4 answers
Ascending order mysql
SQL
0 vote122 views1 answer
Oracle list user locked
SQL