/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 votes245 views2 answers
Sql query to copy data from one column to another
SQL
2 votes218 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote209 views8 answers
Convert sql query to linq online
SQL
0 vote193 views2 answers
How to combine diff colmun value using group by postgres
SQL
6 votes266 views2 answers
Mysql check auto increment value
SQL
12 votes187 views2 answers
Delete all data in neo4j
SQL
2 votes240 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote189 views2 answers
Sqlalchemy core in clause
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
1 vote183 views1 answer
Stop mysql server mac
SQL