title: Stop PostgreSQL from spliting value(s) in multiple lines?
body: <p>I'm converting a binary data (bytea) data type to string using <code>encode(foo::bytea, 'base64')</code> but the output is being split in multiple lines:</p>
  
  <pre><code>-[ RECORD 1 ]-+-----------------------------------------------------------------------
   req_id       | 132675
   b_string     | d4IF4jCCBd4GCSqGSIb3DQEHAqCCBc8wggXLAgEDMQ0wCwYJBAIBMIGYBgZngQgBAQGg+
                | gY0EgYowgYcCAQAwCwYJYIZIAQAwCwYJYIZIAWUDBAIHUwUdH0JybzpY2evf+v9Xg86b+
                | HSGTGYBIb/QwJQIBAgQg1M6/cJ+S39XY1lm43oenxJNLrYcc3hVw7fgwJQIBDgQgIAil+
                | 1JnYbdS0p4pK07kMkb/dbMcxryx6mqbLTzx+YJ6gggQbMI2gAwIBAgIESS7vwTAKBggq+
                | LUxRjUXbTgfGwUKOFwemsc4KXbsLZ13MkbNfAQ==
  </code></pre>
  
  <p>How can get a single string instead?</p>
  
  <p><strong>UPDATE: based on the solution by @LaurenzAlbe</strong> </p>
  
  <p>Just for the completeness, this is what I end up doing the gave me the result I wanted:</p>
  
  <pre><code>translate(encode(foo::bytea, 'base64'), E'\n', '')
  </code></pre>