/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

2 votes114 views2 answers
Spring import sql
SQL
-1 vote108 views1 answer
Sql syntax create timestamp column
SQL
0 vote125 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote117 views1 answer
Azure sql server check foreign key
SQL
0 vote97 views1 answer
Mysql regex exact match
SQL
0 vote131 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote117 views1 answer
Sql string contains case sensitive
SQL
0 vote124 views1 answer
Mysql foreach insert
SQL
0 vote122 views1 answer
Is not numeric sql
SQL
0 vote119 views1 answer
Windows aggregate functions in postgresql
SQL