/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

3 votes364 views2 answers
Oracle drop column
SQL
0 vote345 views1 answer
Sql string length postgresql
SQL
0 vote384 views1 answer
Psql get table data types
SQL
26 votes348 views6 answers
Modify column name in sql
SQL
4 votes344 views1 answer
Check database name postgresql
SQL
-2 votes376 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes344 views1 answer
Oracle cpu per session
SQL
7 votes375 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote345 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote339 views1 answer
Update top 100 sql
SQL