/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

1 vote363 views1 answer
Mysql check if string contains comma separated
SQL
1 vote392 views1 answer
Import mysql dump database command line linux
SQL
1 vote366 views1 answer
Mysql show queries running
SQL
4 votes337 views1 answer
To date oracle with time
SQL
5 votes370 views1 answer
AND OR NOT operators sql
SQL
0 vote425 views1 answer
Mariadb change column type
SQL
-2 votes369 views2 answers
Union all in sql
SQL
4 votes356 views4 answers
Sqlite describe table
SQL
0 vote402 views1 answer
Fetching data from mysqldb
SQL
0 vote359 views1 answer
How we can perform acid Operations in sql with examples
SQL