title: Postgres psql output strings without escape characters
body: <p>I have a column in PostgreSQL that is of type bytea that usually has text data. I want to get the value of that column for a certain row with newlines and tabs intact rather than the octal escape characters that psql is outputting. For example, I run:</p>
  
  <pre><code>psql -Atc 'SELECT my_column from my_table limit 1;'
  </code></pre>
  
  <p>And I get output like:</p>
  
  <pre><code>Foo\015\012Bar\011This is some text.
  </code></pre>
  
  <p>Instead I want:</p>
  
  <pre><code>Foo
  Bar This is some text.
  </code></pre>
  
  <p>I realize I can just use grep, which is what I'm doing, but I'm wondering if there's some simple way to do this via psql. I tried type casting the value to type text, but that didn't seem to help.</p>