title: Postrgres Regex to replace part of a String
body: <p>Is there a regex that could be used in the update statement that would replace a part of a String?</p>
  
  <p>I have a row that has a consistent string across all the rows, so I'm looking for a regex pattern that would look for a specific pattern and replace that? For example, say I have a column row that has the following value:</p>
  
  <pre><code>{
    "test": "Some Value"
    ....
  }
  </code></pre>
  
  <p>What I'm essentially looking for is to match anything with "test": and replace that with whatever I give (for example., "test": "Some Other Value")</p>