/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 vote117 views1 answer
Oracle compile schema
SQL
0 vote137 views1 answer
Search column name sql
SQL
1 vote145 views2 answers
Get table column names sql laravel
SQL
7 votes142 views3 answers
Select latest entry in sql table
SQL
1 vote136 views1 answer
Database Queries
SQL
1 vote155 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote125 views1 answer
Jooq convert using gbk
SQL
1 vote132 views2 answers
Mysql current user
SQL
2 votes138 views1 answer
Oracle drop table free up space
SQL
1 vote132 views1 answer
Rows to comma separated values in mssql
SQL