I'm Pretty guaranteed that could do the job in MySQL (my track record), however it doesn't appear to operate in postgres. The error I get is: The Established statement is made use of with the UPDATE statement to assign new values to columns having outdated values. This website demonstrated how https://pgupdate.in/