Using pgAdmin, how can I see the entire string value for a row when the value is very long?
For example, the value may be comma-separated values (CSV) content with hundreds or thousands of characters. Furthermore, the value may contain newline characters.
When doing queries in pgAdmin’s SQL tool, the results pane only shows a few dozen characters, and then suppresses the display of any more. Is there some way to see all of the text value?
Any way to export the results of a query to a text file or a text window perhaps?
"11.21","8,11 (...)"
– Basil Bourque Nov 20 '15 at 1:09