Postgresql – See entire string from a lengthy text field in pgAdmin

pgadminpostgresql

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?

Best Answer

  • 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.

Related Question