/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

25 votes360 views3 answers
How to use a database to see tables mysql
SQL
0 vote359 views1 answer
Mysql where in maintain order
SQL
8 votes357 views1 answer
Sql remove leading spaces
SQL
1 vote348 views1 answer
Add many column to sap iq table
SQL
0 vote382 views1 answer
Postgres rename database
SQL
0 vote321 views1 answer
How to fetch highest score in minimum time using mysql
SQL
1 vote341 views1 answer
Sometimes i cant edit sql developer
SQL
28 votes335 views4 answers
Show tables mysql
SQL
2 votes338 views1 answer
Mysql how to store lat,lng
SQL
6 votes372 views3 answers
How to delete table sqlite
SQL