Stack Exchange network consists of 182 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I have 2 tables in postgres like:
table B like:
I want to fill the id column in table B based on table A. So the result will be like this:
This is a simple UPDATE join syntax
SET id = unique_id
WHERE tableA.unique_coords = tableB.coords;