/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 vote196 views1 answer
Sql server concat null
SQL
2 votes190 views3 answers
Replace null in sql
SQL
2 votes202 views1 answer
Mariadb json select
SQL
0 vote244 views1 answer
Redshift running queries
SQL
0 vote198 views1 answer
Postgres statistics
SQL
3 votes191 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote266 views1 answer
How to show current database in mysql
SQL
0 vote207 views1 answer
Install sql server in ubuntu 20.04
SQL
15 votes194 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote182 views1 answer
Mysql select all table that have field names
SQL