/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

3 votes335 views1 answer
Mysql group_concat distinct
SQL
31 votes289 views3 answers
SQL Server change column data type
SQL
2 votes304 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote290 views1 answer
Java check if something is in mysql table
SQL
0 vote282 views1 answer
Show create table in postgresql
SQL
0 vote330 views1 answer
Mysql insert multiple rows based on select
SQL
2 votes287 views1 answer
How to delete view in sql
SQL
0 vote309 views2 answers
Dumping sql table
SQL
0 vote316 views2 answers
How to get max from each department in sql
SQL
0 vote291 views5 answers
Sql table intermédiaire
SQL