3

A have a TEXT column in which the values contain newlines. When I query the column in pgAdmin, I only see the first line of each value. Can I make pgAdmin show multiple lines in a cell?

2
  • I was able to get the text I wanted to see by using replace(my_column, E'\n', ' '). Jun 11 '18 at 17:30
  • I'd also like to know if there's a better way to see the output. I'm trying to get json output, but I can only see the first line right now.
    – erjiang
    Jul 19 at 16:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.