title: postgresql - replace all instances of a string within text field
body: <p>In postgresql, how do I replace all instances of a string within a database column?</p>
  
  <p>Say I want to replace all instances of <code>cat</code> with <code>dog</code>, for example.</p>
  
  <p>What's the best way to do this?</p>