The following bug has been logged online:
Bug reference: 5867
Logged by: Richard Neill
Email address: postgresql@richardneill.org
PostgreSQL version: 9.03
Operating system: Linux
Description: wish: plpgsql print table for debug
Details:
When debugging a plpgsql function, it would be really amazingly useful to be
able to do a regular psql-style SELECT, and have the result printed to
screen.
Something like:
Raise Notice table 'SELECT .... '
and then plpgsql would run the query and dump the result to screen, using
its helpful formatting.
As far as I can see, this isn't possible (though there are a lot of people
searching for how to do it), and the only workaround is to manually handle
the looping and formatting, raising lots of individual notices. This makes
debugging much harder than it should be.