/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 vote207 views1 answer
Sql server user permissions and roles
SQL
-1 vote153 views1 answer
Oracle db list usernames
SQL
15 votes228 views5 answers
Select all tables sql
SQL
0 vote260 views1 answer
Mysql workbench not showing schemas
SQL
2 votes185 views1 answer
Oracle run_duration average
SQL
0 vote213 views1 answer
Database traccar
SQL
0 vote198 views1 answer
Pl/sql loop example
SQL
0 vote239 views1 answer
Remove mysql from centos 7
SQL
15 votes195 views4 answers
Mysql where value is null
SQL
0 vote218 views1 answer
Oracle table privileges
SQL