Is there an easy way in PostgreSQL to escape newlines, carriage returns, and tabs?

Let's say I want to escape these to see a similar string SELECT * FROM ( VALUES (E'\r\n\t FOO BAR \t\n\r') ) AS t(str); How do I get the c-style escapes, \r\n\t FOO BAR \t\n\r back out? SELECT * FROM ( VALUES (E'foo\nfoo',E'\n\tBAR\t','baz'), (E'quz','qaz','quz') ) AS t(x,y,z); x | y | z -----+------------------+----- foo+| +| baz foo | BAR | quz | qaz | quz (2 rows) Want instead.. x | y | z ----------+------------------+----- foo\nfoo | \n\tBAR | baz quz | qaz | quz (2 rows)