title: how to append additional characters into a string in postgresql
body: <p>For Example let's take <code>The quick brown fox jumps over the lazy dog</code> is the <em>string</em>.<br> In this string I need to append <code>_</code> instead of <code>spaces</code> in between two <code>words</code> and append word <code>tag:</code> in front of each <code>word</code>. </p>
  
  <p>i.e<br><code>tag:The_tag:quick_tag:brown_tag:fox_tag:jumps_tag:over_tag:the_tag:lazy_tag:dog</code><br></p>
  
  <p>How to do this with <code>Postgresql</code></p>
  
  <hr>
  
  <p>I've tried </p>
  
  <pre><code>select replace('The quick brown fox jumps over the lazy dog', ' ', '_')
  </code></pre>