title: Swap multiple column values in postgres
body: <p>I am trying to swap multiple column values that were incorrectly swapped due to backend code. I am trying to use the following:</p>
  <pre><code>UPDATE insured
  SET address1=(:risk_address1_var:=address1), address1 = risk_address1, risk_address1 = :risk_address1_var;
  </code></pre>
  <p>It's not working like it works for mysql as temp variable(using @). I want to execute this sql query in the liquibase migration code.</p>