title: In Postgresql how to get base64 decoded values as string instead of hex representation?
body: <p>In Python I encoded one string,</p>
  
  <pre><code>&gt;&gt;&gt; base64.b64encode('1111')
  'MTExMQ=='
  </code></pre>
  
  <p>Now when I try to decode it in Postgresql I got Hex values instead of the original string.</p>
  
  <pre><code>=# select decode('MTExMQ==', 'base64');
  
     decode   
  ------------
   \x31313131
  </code></pre>
  
  <p>How can I get the original string without any change in Postgresql?</p>