/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 vote109 views1 answer
Launch sql script from docker in mysql
SQL
0 vote117 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote109 views2 answers
Search stored procedures
SQL
2 votes153 views1 answer
Oracle insert or update
SQL
1 vote134 views1 answer
Ubuntu access database from terminal
SQL
1 vote118 views1 answer
Float precision in psql
SQL
0 vote114 views1 answer
Delete insert record in sql server
SQL
0 vote177 views1 answer
How to rename a database in tsql
SQL
3 votes131 views1 answer
Oracle limit user tablespace
SQL
0 vote121 views1 answer
Select row with latest date mysql
SQL