/SQL/Copy from one table to another postgres using matching column

Copy from one table to another postgres using matching column

UPDATE Table2 --format schema.table_name
SET 
ref_id2 = table1.ref_id1
FROM table1 -- mention schema name
WHERE table1.id = table2.id
AND 
table1.a_ref1 = table2.b_ref1;

Source: stackoverflow.com

Similar codes

0 vote125 views1 answer
Mysqli_connect using prepare statement
SQL
6 votes117 views1 answer
Postgres get size of database
SQL
0 vote113 views1 answer
2020 new year
SQL
1 vote130 views1 answer
Sql random sampling per group
SQL
0 vote124 views1 answer
Postgresql function ROUND
SQL
0 vote139 views1 answer
Oracle job session
SQL
12 votes173 views2 answers
Update column data type postgres
SQL
-1 vote122 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote109 views1 answer
Fetch second word from a string in ms sql
SQL
6 votes116 views4 answers
How to remove unique key in mysql
SQL