title: Regular expression find and replace in Postgres
body: <p>I have a table that contains a number of rows with columns containing a URL. The URL is of the form: </p>
  
  <p><code>http://one.example1.com:9999/dotFile.com</code></p>
  
  <p>I would like to replace all matches in that column with <code>http://example2.com/dotFile.com</code> while retaining everything after :9999. I have found some documentation on regexp_matches and regexp_replace, but I can't quite wrap my head around it. </p>