Postgresql – pgAdmin to display multiple result sets

It looks like you see a difference between the clients you use.

In my experience the different PostgreSQL clients need very different times for displaying the data they got from the server. Far the fastest was psql and then pgAdminIII, EMS SQL Manager and phppgadmin in who-remembers-what order.

When tried with commands which return no or few rows, the difference is usually negligible or at least very small. Furthermore, you should see the same actual time consumed (with the usual small differences) when you issue an EXPLAIN ANALYZE ... command instead of the actual query which returns the data much slower in one client than the other.

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