/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 vote302 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
2 votes299 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote320 views3 answers
Sql server import json
SQL
0 vote339 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote351 views1 answer
Having all mysql
SQL
0 vote532 views1 answer
Get first match in each group mysql query
SQL
2 votes311 views1 answer
How to make insert script from table in SQL server
SQL
3 votes299 views2 answers
Having in mysql
SQL
1 vote302 views1 answer
Mysql history command
SQL
8 votes312 views1 answer
Alter tablespace add datafile autoextend
SQL