title: Convert Postgres IPv6 column TEXT field into JSON
body: <p>Trying to convert a <strong>text</strong> field to a <strong>JSON</strong> field in Postgres. The field was an IPv6 address those having multiple semicolons e.g.: <em>&quot;14:eth1:vTA1:::4:&quot;</em></p>
  <p>Trying to run smth like:</p>
  <pre><code>ALTER TABLE data ALTER COLUMN ipv6 TYPE jsonb USING ipv6::jsonb;
  </code></pre>
  <p>Results in:</p>
  <blockquote>
  <p>Failed to convert text field to JSON. Details: invalid input syntax for type json
  DETAIL:  Expected end of input, but found &quot;:&quot;.</p>
  </blockquote>
  <p>Any clues how to do it properly?</p>