title: How to convert a XML into JSONB within Postgres
body: <p>I have a table, <code>Table1</code> that contains a <a href="https://www.postgresql.org/docs/9.4/static/datatype-xml.html" rel="nofollow">XML data type</a> column, <code>ColumnA</code> and another JSONB column <code>ColumnB</code></p>
  
  <p>How do I convert the data from <code>ColumnA</code> into <code>ColumnB</code>, presumably using an SQL <code>UPDATE</code>  statement. Is there a built-in function in Postgres that does this?</p>