/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 vote139 views1 answer
How to install mysql without admin rights
SQL
0 vote146 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote130 views1 answer
Postgres add prefix to primary key
SQL
2 votes134 views1 answer
Set boolean flasksql
SQL
0 vote142 views1 answer
Create or replace view postgress
SQL
1 vote148 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote140 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote145 views1 answer
Drop index in sql
SQL
0 vote141 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
19 votes137 views6 answers
Laravel sql query
SQL