See entire string from a lengthy text field in pgAdmin?
Open pgAdminIII,
Select your database,
Use the Magnifying Glass button, i.e. "Execute arbitrary SQL queries"
Instead of running your query using the green triangle  "Execute Query", choose
the button two to the right of that - i.e. "Execute Query, write result to file".
Choose your destination, then you can view arbitrary length text in your chosen file destination.
You can also use psql which will show text, but will scroll if that's any use. Also, there would be the possibility of scripting your query output using different delimiters.